Getting most up to date data while determining the lack of data

  • What Grafana version and what operating system are you using?
    Grafana Home Assistant Plugin. Grafana v9.5.1

  • What are you trying to achieve?
    I am trying to get the Stat visualization to display the most up to date data until a certain amount of time without data has passed at which point it would show no value.

  • How are you trying to achieve it?
    I have attempted to use the Last (including nulls) Calculation in the Value Options for Stat to show that the data has not arrived.

  • What happened?
    The $interval will never exactly match the rate at which the data is coming in so there will always be times where the data will come in in the next few seconds but the $interval GROUP BY has already added a null result for the next minute. Thus displaying a no value where I would still like to see one.

Any help trying to achieve this would be appreciated.

So what value do you want to see where there is none