How to display the weekly average of all timestamps in date/time field?
I have a card that I need to display the previous week's average of tickets created in each hour. The example of the data is attached however, the short story is 24 hours display and the average total tickets created over the previous week by hour. Also attached an example of my attempt of the card filtering Previous Week, by Hour.
Thanks in advance!