Days to close tickets with average as a line
Good morning everyone:
I have just started using Domo and I have been tasked with taking an exec prenintation out of Excel and into Domo.I cannot figure out how to build this chart.
- X - Axis: Date of ticket raised
- Y - Axis: Count of Ticket ID
- Stacked Bar: Grouping of ticket age
- Line: Average ticket age
This is what the current Excel chart looks like:
I have been able to get everything apart from the line to work. I have written the beat mode calculation to group the ticket ages but I cant figure out how to create a series for the line to show average age for the given period.
Could someone please point me in the right direction?
Best Answer
-
Do you have a column with the ticket age already calculated or are you doing that as a beastmode?
You could create something like this:
AVG(DATE_DIFF(`closedate`, `opendate`))
Put the AVG beastmode calculation as your first value in the 'Y Axis' area. Then create separate beast modes for each of the date ranges and add those beastmodes (making up your stacked bar) one after another in the 'Series' section.
For reference, I have a % change line with two bars on one of my charts, you can see how I broke the series up here:
Hope that helps getting you started.
Let me know if you have any other questions,
Valiant_Ronin
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Answers
-
Do you have a column with the ticket age already calculated or are you doing that as a beastmode?
You could create something like this:
AVG(DATE_DIFF(`closedate`, `opendate`))
Put the AVG beastmode calculation as your first value in the 'Y Axis' area. Then create separate beast modes for each of the date ranges and add those beastmodes (making up your stacked bar) one after another in the 'Series' section.
For reference, I have a % change line with two bars on one of my charts, you can see how I broke the series up here:
Hope that helps getting you started.
Let me know if you have any other questions,
Valiant_Ronin
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1 -
Thanks for the reply Valiant_Robin. It took me a while to get the calculation for the average line to work (still learning the MYSQL syntax) but I now have the chart.
Bonus advantage of your method is that I can order the series in a sensible manner.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive