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?