I am working on creating a filter that can display the updated time spent on tickets within the last 7 days. It's relatively straightforward to show the total time spent on tickets over their entire lifespan. However, our CEO has requested a dashboard that specifically showcases the recently updated time spent.
For instance, if a ticket originally had a total of 200 hours logged but has had an update of 6 hours in the past week, we need to figure out how to exclusively display these 6 updated hours from the last 7 days.
I am using this filter to display data in a dashboard.