Improvement to Tautulli integration - Watch duration

[dsfsdbvxc]

Describe your core improvement

The Tautulli integration is fantastic, but would like to add a feature.

The integration provides a watch count, but would love to have watch duration as a sensor too. This is available from Tautulli, so suspect it's possible.

For example there’s already a sensor for the number of people watching: sensor.tautulli_watching

I'm after a new sensor to show the total amount all users have watched each day, so something similar.

Current limitations

This functionality is not currently available in the integration.

Technical benefits

It would add functionality to the already excellent Tautulli integration, part of Home Assistant core I believe.

Additional context

No response

[dsfsdbvxc]

Managed to set this up using a API query, but still be nice to have as part of the integration.

For info, I used this to get the info from the Tautulli API:

rest:
  - resource: "http://XXX.XXX.XXX.XXX:8181/api/v2"
    params:
      apikey: !secret tautulli_api_key
      cmd: get_plays_by_date
      y_axis: duration
    scan_interval: 60
    timeout: 15
    sensor:
      - name: "Tautulli watch duration API"
        value_template: "{{ value_json.response.result }}"
        json_attributes:
          - response

Then set up sensors in Home Assistant to show the total watch duration for today, yesterday, this year and overall:

  - sensor:
      - name: "Tautulli watch duration today"
        unit_of_measurement: "h"
        icon: mdi:television
        state: >
          {% set data = state_attr('sensor.tautulli_watch_duration_api', 'response') %}
          {% if data and data.data and data.data.series %}
            {% set totals = data.data.series | selectattr('name', 'equalto', 'Total') | list %}
            {% if totals and totals[0].data | length > 0 %}
              {% set duration_today = totals[0].data | last %}
              {{ (duration_today | int(0) / 3600) | round(2) }}
            {% else %} 0 {% endif %}
          {% else %} 0 {% endif %}

      - name: "Tautulli watch duration yesterday"
        unit_of_measurement: "h"
        icon: mdi:television
        state: >
          {% set data = state_attr('sensor.tautulli_watch_duration_api', 'response') %}
          {% if data and data.data and data.data.series %}
            {% set totals = data.data.series | selectattr('name', 'equalto', 'Total') | list %}
            {% if totals and totals[0].data | length > 1 %}
              {% set duration_yesterday = totals[0].data[-2] %}
              {{ (duration_yesterday | int(0) / 3600) | round(2) }}
            {% else %} 0 {% endif %}
          {% else %} 0 {% endif %}

      - name: "Tautulli watch duration this year"
        unit_of_measurement: "h"
        icon: mdi:television
        state: >
          {% set data = state_attr('sensor.tautulli_watch_duration_api', 'response') %}
          {% if data and data.data and data.data.series and data.data.categories %}
            {% set totals = data.data.series | selectattr('name', 'equalto', 'Total') | list %}
            {% set dates = data.data.categories %}
            {% if totals and totals[0].data | length == dates | length %}
              {% set year = now().year | string %}
              {% set durations = namespace(sum=0) %}
              {% for i in range(dates | length) %}
                {% if dates[i].startswith(year) %}
                  {% set durations.sum = durations.sum + (totals[0].data[i] | int(0)) %}
                {% endif %}
              {% endfor %}
              {{ (durations.sum / 3600) | round(2) }}
            {% else %} 0 {% endif %}
          {% else %} 0 {% endif %}

      - name: "Tautulli watch duration all time"
        unit_of_measurement: "h"
        icon: mdi:television
        state: >
          {% set data = state_attr('sensor.tautulli_watch_duration_api', 'response') %}
          {% if data and data.data and data.data.series %}
            {% set totals = data.data.series | selectattr('name', 'equalto', 'Total') | list %}
            {% if totals and totals[0].data | length > 0 %}
              {% set total_duration = totals[0].data | sum %}
              {{ (total_duration | int(0) / 3600) | round(2) }}
            {% else %} 0 {% endif %}
          {% else %} 0 {% endif %}

Seems to work well, hope that helps someone in the future!