Multi Line Graph with Different Time Zones
Hello,
I have a dataset here where there are 4 time zones, EST, CST, MST, PST and the fields are this CST Created Date, MST Created Date, PST Created Date, Created Date Last one is EST by default.
Example format: 2019-03-11 10:22:17
So, I have extracted the hour using HOUR (`MST Created Date`
) and for others as well. But I need a multi-line graph where x axis would be 0 to 23 and I need 4 lines for each time zone, and I want to count one particular field from my dataset.
How to achieve this in domo?
Answers
-
Make sure your dataset has columns for the hour extracted from each time zone's created date (CST Hour, MST Hour, PST Hour, and EST Hour). Create a Magic ETL to aggregate your data by hour for each time zone, Group by with the count of your fields for each time zone.
Then use a multi line graph and set the x-axis for hours from 0 to 23. On the y-axis, display the aggregate count.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Thanks for the response, instead of creating an additional dataset can I write a series beast mode formula and achieve this?
0 -
Yes, I think you could use beast mode. Build some calculations for each time zone, and pivot the data to get everything in a single column. I'd have to create some sample data and try it to give a better answer.
Beast Mode for EST:
HOUR(Created Date
)Beast Mode for CST:
HOUR(CST Created Date
)Beast Mode for MST:
HOUR(MST Created Date
)Beast Mode for PST:
HOUR(PST Created Date
)CASE
WHEN `Time_Zone` = 'EST' THEN HOUR(`Created Date`)
WHEN `Time_Zone` = 'CST' THEN HOUR(`CST Created Date`)
WHEN `Time_Zone` = 'MST' THEN HOUR(`MST Created Date`)
WHEN `Time_Zone` = 'PST' THEN HOUR(`PST Created Date`)
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
I did not understand the solution, how would my final dataset look?
0 -
I would need to do it see it more specifically.
Hour
Time_Zone
Count
0
EST
10
1
EST
15
2
EST
8
...
...
...
0
CST
12
1
CST
9
2
CST
11
...
...
...
0
MST
7
1
MST
14
2
MST
13
...
...
...
0
PST
5
1
PST
10
2
PST
9
...
...
...
Group by Hour and Time_Zone. Aggregate the counts of your specific field.
Create a new card and select the "Multi-Line Chart" type. Drag the Hour field to the X-axis. Drag the Time_Zone field to the Series. Drag the field you want to count to the Y-axis.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Thanks for the response.
But I have my data like this in table format how to show this in 4-line graphs (each time zone) using a beast mode in the existing dataset rather than creating a new one.0 -
Can anyone help me with this please?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive