Do not use time range but latest value for some panels in a dashboard

Hello,

I am trying to implement a dashboard looking like this:

What I would like to achieve is:

  • The top numbers should always display the latest value, no matter what time range is selected
  • for the graphs below, time range should be normally selectable
  • Top numbers and graphs use the same data source

I didn’t find a fitting option, at the moment the top numbers take the latest value of the selected time range. Could someone point me in the right direction?

Best regards
Philipp

Hi,

I’m exactly the same problem. Did you somehow find a solution yet?

Hi @henningwoehrmann,

I am using InfluxDB as Data Source. You can edit the query sent to the Data Source directly. In there, you just have to remove the “$timefilter” part - Grafana puts the time range selected in the panel there.

I shortened my queries from

SELECT last("value_number") FROM "states_history" WHERE ("state_id" = '796231') AND $timeFilter GROUP BY time($__interval) fill(null)

to

SELECT last("value_number") FROM "states_history" WHERE ("state_id" = '796231')

as I only need the last value. This works.

Best regards
Philipp