Possible to show the relative usage percent?

[kendrome]

I was thinking it would be more useful to be able to see the relative usage percent. Let's say you are 15 days into the month with 30 days, and you have used 500 GB you would be at 100% relative usage. This way you can see where you are at and if you need to cut back on usage.

[MikeExMachina]

Yes! This would be great to plot on a graph against actual current usage. If your current usage is above the relative line your burning to hot and you need to back off, under the line and you're good.

[kendrome]

Here is what I'm using for now in NodeRed, I'm then updating an input_number with msg.percent

`var daysInMonth = Number(msg.data.new_state.attributes.end_date.match(//(\d\d)//)[1]);
var day = new Date().getDate();

msg.totalHours = daysInMonth * 24;
msg.currentHours = (day - 1) * 24 + new Date().getHours();
msg.gbPerHour = 1000 / msg.totalHours;
msg.ratioGB = msg.gbPerHour * msg.currentHours;
msg.percent = ((Number(msg.payload) / msg.ratioGB) * 100).toFixed(1);

return msg;`

[johnwarne]

Not sure if this would help your particular scenario, but I've created some template sensors to handle this kind of thing through YAML. It's probably not the prettiest code, but it's been working for my purposes.

- platform: template
  sensors:
    days_in_current_month:
      value_template: >
        {% if now().month in [1,3,5,7,8,10,12] %}
          31
        {% elif now().month in [4,6,9,11] %}
          30
        {% elif now().month == 2 and ((now().year-2000) % 4 > 0) %}
          28
        {% elif now().month == 2 and ((now().year-2000) % 4 == 0) %}
          29
        {% endif %}
      entity_id: sensor.time
    expected_xfinity_data_usage:
      friendly_name: Expected data usage
      value_template: "{{ (((((now().day)|int - 1) / states('sensor.days_in_current_month')|int) + (now().hour / 24 / states('sensor.days_in_current_month')|int)) * 1024) | int }}"
      unit_of_measurement: 'GB'
      entity_id: sensor.time
    xfinity_expected_vs_actual:
      friendly_name: Expected vs actual usage
      value_template: >
        {% if (states('sensor.xfinity_usage')|int) > (states('sensor.expected_xfinity_data_usage')|int) %}
          Over by {{ ((states('sensor.xfinity_usage')|int) - (states('sensor.expected_xfinity_data_usage'))|int) | int }} GB ❗
        {% elif (states('sensor.xfinity_usage')|int) < (states('sensor.expected_xfinity_data_usage')|int) %}
          Under by {{ ((states('sensor.expected_xfinity_data_usage')|int) - (states('sensor.xfinity_usage'))|int) | int }} GB ⭐
        {% else %}
          Right on track!
        {% endif %}
      entity_id: sensor.time
    xfinity_over_under:
      friendly_name: Xfinity over/under
      value_template: "{{ ((states('sensor.xfinity_usage')|int) - (states('sensor.expected_xfinity_data_usage'))|int) | int }}"
      entity_id: sensor.time
      unit_of_measurement: 'GB'