I want to filter a report from yesterday 2.00 pm until today 2.00 pm.
How to do this?
1 Like
Hello @pantelis, the data in my sample dataset is a bad example but the calculation will still resolve your issue!
My thought would be to use a calculated field and filtering that instead of building the rolling date/time functionality directly into a filter. I’ll post a picture of my calculated field where I added comments to explain the functionality:
Also, here is a link for the Arena dashboard I created: Rolling Date Filters with Time
Basically, you can apply that calculated field as a filter on the required visuals, and just check if the returned value is equal to 1. That should allow you to set a rolling date filter account for date and time. Let me know if you have any questions!
7 Likes
Hi @pantelis
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @pantelis
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!