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?
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:
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,
**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
- 7.6K All Categories
- 917 Connectors
- 242 Workbench
- 472 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 31 Visualize
- 197 Beast Mode
- 2K Charting
- 7 Variables
- 14 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 19 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部