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
#2
In panel options there’s is a time range tab where you can specify panel time ranges overrides
viapass
January 6, 2018, 10:33am
#3
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
#4
Why?
One panel can show last 5min, another last 1d, another last 7d
viapass
January 6, 2018, 10:39am
#5
torkel:
panel can show last 5
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
#6
So why not use panel time range override ???
viapass
January 11, 2018, 3:40pm
#7
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
#8
but why not set time range on each panel?
1 Like
viapass
January 11, 2018, 4:02pm
#9
oooooooh My gooood yes indeed i forget this function !
Thanks torkel
dsb
January 29, 2019, 3:11pm
#10
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!
is it has solution with Grafana 6+?
the setting board looks different from upper image.
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.
1 Like
Hello zncaudata! Please check out these threads for more information on how to set time range on each panel for Grafana 6+:
Hello,
I often see tabs in documentation but on my installation I can’t see any of them in the following view:
[59]
I’m running on Grafana v6.3.5 (67bad72)
What I’m doing wrong?
Regards
SchiSchi
Hi all, hopefully something really dumb… I’m trying to get different time ranges for different graph panels on a single dashboard. I’m sure I’m missing something obvious, According to the docs, I should see this:
[image]
However, what I actually see is this:
[image]
Hi,
Where is panel options in Grafana 8?
I don’t see timeoveride option
1 Like
Panel’s Time range setting.
Edit → Query options → Relative time to set the Time rage.
Interval can also be set here.