Two series on a graph card - Zendesk
I'm trying to create a card with a line graph that shows two columns in my dataset. I'm currently importing Zendesk data which is essentially a list/data table of support tickets. There's one column that shows the date/time a ticket was created and one that shows the date/time a ticket was solved.
I ideally want to plot a line graph that shows both the created and solved figures for each day. Dates along the X axis and number of tickets along the Y with two series (created and solved) as two lines.
Unfortunately, I can't figure out what to map to the X axis. I can create a graph showing only one series by doing a Count of the tickets created as both the X and Y axis, but I can't add the Count of the tickets solved because this is filtered to show only the tickets that were created.
Any thoughts would be much appreciated. In my mind, I just need a list of dates to map to the X axis, but I'm not sure if this is the right answer/how to go about it.
Thanks so much for your help in advance.
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部