Check if value is not updated last 24 hours


I’ve made a query that shows the max reached value all-time of each solar panel in my dashboard from my influxdb:

    - name: Maximaal vermogen ooit
        field: value
        where: '"entity_id" = ''envoy_122244026326_current_power_production'''
        group_function: max
        database: homeassistant
        measurement: '"homeassistant"."autogen"."W"'

Now I want the value to be a different color if the value is changed in the last 24 hours. I can’t figure out how to get the last changed value date and based on that to change the color of the value in my dashboard.

Hope that someone can help me with this :slight_smile: