Filter dynamic time range

[stefan_eggersto]

Is it possible to filter the time with a time range only, e.g. from 5:30am yesterday to 5:30am today?

[sinisa_zubic · Accepted solution]

Hi Stefan,
this should be the query

fetch logs, from: bin(now()-1d, 1d) + 17h + 30m, to: bin(now(), 1d) + 17h + 30m

basically, you make use of the from an to parameters. 

• with now()-1d, you specify the timeframe exactly 24h ago
• then with bin(now()-1d, 1d) you round it to the start at the day, so at midnight
• then you add the time of the day with + 17h + 30m

Best,

Sini

[Maheedhar_T]

Also,
If your timezone is not in UTC then you might have to subtract/add that from the timeframe as Sini mentioned above.
My timezone is UTC+5:30 so I had to 

from: bin(now()-1d, 1d) -5h -30m, to: bin(now(), 1d) -5h - 30m

do this to get the data of previous day.

Thanks @sinisa_zubic this saved lot of effort for me 😃.

Regards,

Maheedhar.