Yesterday Time Range - how to graph just yesterdays data

1

Hi,

I have been trying to use override and timeshift to show results for yesterday in a time series graph that just displays yesterdays measurements for the 24 hours.

I have tried all sorts of combinations but just can’t seem to get there. Maybe its not possible or hopefully somebody smarter than me can help. The attached pic shows the closest I can get and the settings but it is the 27 April today and it displays 25 April and part of 26 April up to the time right now. I just want to show 24 hours of 26 April.

image
image1812×619 77.6 KB

2

OK I think I got it. I don’t know why but this seems to work.

image
image1807×636 73.1 KB

3

I know this was along time ago, but what was the solution?
I want to display all my data up until Yesterday and/or up until the last whole hour.
Thanks.
P.S I am probably where you were 5yrs ago :slight_smile:

4

@jamesfd70

At the risk of pointing out the obvious, I presume you already tried selecting Yesterday in the time picker? You can set this to always display (there is a checkbox when you save the dashboard).

image
image1396×284 34.7 KB

Also, this might help.

5

Hi Grant,
It wasn’t a silly question however, it doesn’t work.
I also tried -1h/h because I want to limit the data i query to but neither worked. :sob:.
Thanks.
P.S I hope you can red this it’s all white on my iPad :roll_eyes:

IMG_8938
IMG_89382388×1668 350 KB

6

Hi @jamesfd70

So when you select Yesterday in the time picker, it does not show you yesterday’s data?

image
image1263×537 104 KB

Example from play.grafana.org of yesterday’s data:

image
image1921×776 240 KB

And here is an example of yesterday’s data plus today’s data up to the last whole hour:

image
image1919×780 235 KB

7

Thank you that’s just what we are looking for. Very much appreciated. I was looking to display the past 3 hours however we have a moving average which was displaying odd data at the end - your -1m/m (-2m/m in our case) worked perfectly.

8

P.S Any Idea how i get rid of my personal details from the post!!! Thanks.
I now know how to edit! :slight_smile:

1 Like
9

Unfortunately, I jumped the gun. The race conditions where such that things looked good but sadly not.
As you can see the chart displays a small branch of data to the right which has not been calculated using the moving average and thus looks odd!. I believe this is data outside of the 2m rolling average. So it all depends on when the chart is refreshed and what data is in the pipe. Thanks.

screenshot 2023-06-09 08.48.13
screenshot 2023-06-09 08.48.131911×493 108 KB

10

What is your data source?

11

InfluxData Cloud. A Hosted service.

12

Can you please show us the query you are using that leverages the time picker values (minus sensitive stuff)

Instead of being bound with grafana time picker maybe just use flux itself

from(bucket: "birds")
    |> range(start: -2d)
    |> filter(fn: (r) => r._measurement == "migration")
13

Here you are not too much to hide :grinning:
from(bucket:“${MyBucket}”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == “${MyMeasurement}”)
|> filter(fn: (r) => r.host == “${MyLocation}”) |> filter(fn: (r) => r._field == “value”)
|> drop(columns: [“aaa”, “bbb”])
|> map(fn: (r) => ({ r with host:“MyLoc” }))
|> timedMovingAverage(every: ${MyInterval}, period: ${MovingAverage})

14 
from(bucket:"${MyBucket}")
|> range(start: -2d)
|> filter(fn: (r) => r._measurement == "${MyMeasurement}")
|> filter(fn: (r) => r.host == "${MyLocation}") |> filter(fn: (r) => r._field == "value")
|> drop(columns: ["aaa", "bbb"])
|> map(fn: (r) => ({ r with host:"MyLoc"}))
|> timedMovingAverage(every: ${MyInterval}, period: ${MovingAverage})
15

The time values are:-
From: now -3h
To: now-2m/m

16

you originally stated you want yesterday’s 24 hours. Is that not the case?

17

That was the example I gave but my issue was the extra period of data that appears to the right if the chart. Whatever time period I select, Grafana displays an extra point of data between the last time and the current time - thus the extra point which has not been smoothed by the moving average and frequent looks odd.

18

What do you see when you run that query in influx explorer?

19

Unfortunately I can’t run this in influx explorer as ironically the cloud version doesn’t support the flux language, only SQL.

20

That may be the problem. I have set up an InfluxDB Cloud account (which stores data in their new iOX system) that (as you pointed out) only uses SQL in that interface. Influx correctly states that you can still use a Flux query in Grafana to query the iOX data, but I found that even some simple graphs came out slightly different looking. I raised an issue (this was months ago) and the reply was something like “We’re working on it.”