How to configure time range in dashboard

Grafana Time Series Panel
1

  • What Grafana version and what operating system are you using?
    I am using managed grafana

  • What are you trying to achieve?
    If I mention some specific time range in my dashboard ,it does not show as per my configured time range
    example: If I mention like 30-06-2024 to 02-07-2024
    but my dashboard does not shows the result as per my condition

  • How are you trying to achieve it?
    Need to sort out that issue.Can you please tell if I made any mistake in that?

2

Hey @priyankag

What’s your datasource? What happen on the dashboard when you change the time range (nothing?)? Can you give us an example of one of your panel?

3

First of all Thanks for reply @codi639
My data source is “Time stream” and it is a streaming data .If I configure some particular time ,it does not show as per my data range ,instead of showing data as per my data range ,it shows different

Screenshot (686)
Screenshot (686)951×331 29.6 KB

Here, I mentioned only to get 6 hours ago data right,but what I am actually getting is data from 17th date . Why it is?What the things needs to be done for this ?

4

I’m not very used to Time stream, but I can still make some guess.

Please check that you actually have data that are from the past 6 hours.
Also, it could be an issue with the query, can you share it?

5

SELECT
t1.time,
t1.measure_value::double AS H2_Value,
t2.measure_value::double AS O2_Value,
(t1.measure_value::double / (t1.measure_value::double + t2.measure_value::double)) * 100 AS H2_Percentage
FROM
“new-trace-sensors-data”.“sensors_data” AS t1
JOIN
“new-trace-sensors-data”.“sensors_data” AS t2
ON
t1.time = t2.time
WHERE
t1.measure_name = ‘GS-AT-012’ AND t2.measure_name = ‘GS-AT-022’
This is the query that I have written for this visual
I have data for past 6 hours.But still it shows like this

6

I think I guessed right: the issue might come from your query.

In your query you are not using a timerange in your WHERE clause. As I said, I’m not very used with Time stream, but you can try to add the variable $timeFilter in your WHERE clause.
doc here

1 Like
7

yeah sure ,Thank you so much @codi639