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

Grafana Dashboards
,
1

Hello,

I am trying to implement a dashboard looking like this:

grafanadashboard
grafanadashboard1607×654 202 KB

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

2

Hi,

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

3

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