Multiple Time range?

viapass · January 5, 2018, 2:54pm

Hi all,

Happy new year to everybody !

I created a new dashboard to get thoses differents graph :

I want to display the evolution of user connection for the day (by hour and by minute) but how i can define a different time range for the week :

Check my MySQL Query (for the week )

****** //////
SELECT COUNT(DISTINCT login) as value, UNIX_TIMESTAMP(when) as time_sec
FROM logs

WHERE when BETWEEN $__timeFrom(now/w) AND $__timeTo(now/w)
AND
type=‘login’

GROUP BY
DATE(when), HOUR( when )
//////// ********

Thanks in advance !

torkel · January 6, 2018, 10:19am

In panel options there’s is a time range tab where you can specify panel time ranges overrides

viapass · January 6, 2018, 10:33am

Hi Torkel

Yes but i can’t configured two time range in same time to display differents times series, you see ?

Thanks !

torkel · January 6, 2018, 10:35am

Why?

One panel can show last 5min, another last 1d, another last 7d

viapass · January 6, 2018, 10:39am

Because i want to display in same time the evolution of user connection Today and of the week, i can understand if it’s not possible but maybe i think i could use this function :
$__timeFrom(now/w)

torkel · January 6, 2018, 1:41pm

So why not use panel time range override ???

viapass · January 11, 2018, 3:40pm

Hi Torkel,

Sorry for the delay, just to confirm we talk to the same thing :

With this tool i can’t see on the two graph in the top of the screen stats of the day, and the third stats of the week.

torkel · January 11, 2018, 3:57pm

but why not set time range on each panel?

viapass · January 11, 2018, 4:02pm

oooooooh My gooood yes indeed i forget this function !

Thanks torkel

dsb · January 29, 2019, 3:11pm

Hello, How do you get two time ranges into 1 panel? also, I’m getting errors that the say the macros
__unixEpochTo and __unixEpochFrom are unknown!

jason80d · November 4, 2019, 6:13am

is it has solution with Grafana 6+?

the setting board looks different from upper image.

zncaudata · December 6, 2019, 10:55pm

Same question as jason80d. Changing the time range within the panels on Grafana 6+ changes the time range for the whole dashboard. I’m not seeing a discrete time range option within each panel like Grafana 5.

ivanahuckova · December 9, 2019, 10:58am

Hello zncaudata! Please check out these threads for more information on how to set time range on each panel for Grafana 6+:

ziaeemehr · July 8, 2021, 9:41am

Hi,
Where is panel options in Grafana 8?
I don’t see timeoveride option

sendaird · September 7, 2021, 1:40am

Panel’s Time range setting.

Edit → Query options → Relative time to set the Time rage.
Interval can also be set here.

pauliusur · December 6, 2021, 12:08pm

simonhuber86 · August 24, 2022, 5:28am

I run Grafana * v9.0.5 on Docker on Synology NAS. I don’t see the Time Range Options. I can’t find override relative time…

I want to add an additional query, to compare the previous year.
How can I do this? Thanks, torkel.

simonhuber86 · August 24, 2022, 5:32am

Thats right. Is it also possible to set different time shifts for two different queries? I want to compare the values with the previous year

marcko · September 19, 2022, 10:44pm

This is the correct way to do it, thanks