Get latest value if "Select time range"

  • What Grafana version and what operating system are you using?
    My Grafana version is Grafana v9.5.2 (cfcea75916)

  • What are you trying to achieve?
    I try to always show the data even if there are no changes in the selected time range.
    For example, if the variable has changed to “true” 7 hours ago and I pot in time range “last 6 hours”, the variable is not seen and says “No data in response”. I want it to look “true” if it is the last value even if it changed 2 days ago.
    Is this possible?

SELECT mean(“value”) FROM “autogen”.“DatosLM” WHERE (“addr”::tag = ‘0/0/5’) AND $timeFilter GROUP BY time($__interval) fill(previous)