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!
Michael
Best Answer
-
Have you tried utilizing a Beast Mode to calculate the Hour of the day:
HOUR(`Date`)
And then using that as your x-axis which selecting last week from your date range selector and then just doing an average of your total tickets? Since you have multiple priorities for each hour you might need to pre-aggregate your data since you're wanting to do an average of a sum (aggregate of an aggregate).
Also make sure to sort your chart by your beast mode so that the hours are in the correct order.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Have you tried utilizing a Beast Mode to calculate the Hour of the day:
HOUR(`Date`)
And then using that as your x-axis which selecting last week from your date range selector and then just doing an average of your total tickets? Since you have multiple priorities for each hour you might need to pre-aggregate your data since you're wanting to do an average of a sum (aggregate of an aggregate).
Also make sure to sort your chart by your beast mode so that the hours are in the correct order.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Works very well! Thank you!
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 705 Automate
- 182 Apps
- 459 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 133 Manage
- 130 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive