I'm trying to generate a report for how many tickets have been submitted within the last hour of the day on a specific day of the week. Specifically, I want to know how many tickets were submitted in the last hour of every Friday.
I'm familiar with filters and dashboards, but the common issue I am running into is that the gadgets in the dashboard need a field that is usually input by the end user. Also, on the places that I can look at the created date, I can't filter for the created time.
Any advice would be welcome, thank you