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 -
Thanks @JasonAltenburg this worked well for me
1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有