31 May 2023 03:00 PM - edited 31 May 2023 03:02 PM
Hi Team,
Solved! Go to Solution.
01 Jun 2023
07:39 AM
- last edited on
01 Jun 2023
03:55 PM
by
sinisa_zubic
Hi Sinisa, the Notebooks app has a snippet for this use case:
Here's the query anyways:
fetch bizevents, from:now()-7d, to:now()
| fieldsAdd hour=toLong(formatTimestamp(timestamp,format:"H")), day_of_week = formatTimestamp(timestamp,format:"EE")
| filterOut day_of_week == "Sat" or day_of_week == "Sun" // Remove weekend days
| filterOut hour <= 5 or hour >= 15 // Remove everything that is not between 5am and 3pm