Multi Line graph with different categories
Hello,
Can anyone guide me on how to represent this data in a multi line graph with 4 different timezones.
Without creating a new dataset.
Best Answers
-
The issue is that your data is wide but the series will only work with your data in a more long format.
If you pull in all of your columns it treats each of those columns as the value and not the hour series as you're wanting.
You need to pivot your data such that you have Case Created Hour, Time Zone and Case Count in your new dataset.
3 | EST | 78
2 | CST | 78
1 | MST | 78
0 | PST | 78
etc.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
IMO, you wouldn't want 4 separate lines because it's all the same cases, so splitting them into four would be misleading. You could concatenate the four time zones into a single axis label. Like:
CONCAT(`Hour`, '|',
CST
,'|',MST
,'|',PST
)And then your x-axis would have labels like:
0|23|22|21 1|0|23|22 2|1|0|23
Or maybe a better approach would be to just include the different timezones as hovertext, available on demand.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
I'm thinking of a series beast mode to achieve this. But not sure how to write it
0 -
The issue is that your data is wide but the series will only work with your data in a more long format.
If you pull in all of your columns it treats each of those columns as the value and not the hour series as you're wanting.
You need to pivot your data such that you have Case Created Hour, Time Zone and Case Count in your new dataset.
3 | EST | 78
2 | CST | 78
1 | MST | 78
0 | PST | 78
etc.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
IMO, you wouldn't want 4 separate lines because it's all the same cases, so splitting them into four would be misleading. You could concatenate the four time zones into a single axis label. Like:
CONCAT(`Hour`, '|',
CST
,'|',MST
,'|',PST
)And then your x-axis would have labels like:
0|23|22|21 1|0|23|22 2|1|0|23
Or maybe a better approach would be to just include the different timezones as hovertext, available on demand.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 601 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 689 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive