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