Create time column for Line chart
Hey guys!
So I want to create a line chart that shows the sum of a total over the course of a 24 hour time period.
I have a timestamp column where I extracted the time but tbh it looks weird.
So I was thinking to improve the chart, is to create a column that include all time over a 24 hour period (not military time) and have the metric fall amongst trendline the metric occurred.
Any suggestions? I may be overthinking this.
Best Answer
-
I think you are correct in creating a new column in your dataset that includes the date/times you want to show in the 24 hour period, even where there is no quantity of likes.
I have attached a couple images to show what I think is your desired output and the data that is powering it, which I set up as a table with a row for each minute of a day, and then entered like quantities in random areas.
I think you already had this selected in your image above, but I selected Hide Empty Values in the chart options as well.
0
Answers
-
Hi @leeloo_dallas are you trying to show all data from the past 24 hours, or a summary of your metric across multiple days?
If it is just the past 24 hours, you do not have to extract the time from your datetime column. You can just set the timestamp as your x-axis, then set the date range to "Previous 24 Hours" with Graph by as "None".
0 -
Hi @MichelleH
I'm trying to show everything over a 24 hour period over the course of the day for the last 24 hours.
I realize it's not a timestamp column and is a date column, since it doesn't include seconds.
So the option for last 24 hours isn't available.
0 -
I think you are correct in creating a new column in your dataset that includes the date/times you want to show in the 24 hour period, even where there is no quantity of likes.
I have attached a couple images to show what I think is your desired output and the data that is powering it, which I set up as a table with a row for each minute of a day, and then entered like quantities in random areas.
I think you already had this selected in your image above, but I selected Hide Empty Values in the chart options as well.
0 -
Thanks @JasonAltenburg this worked well for me
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive