Dashboard Element, Count By Created, Grouped by Time (Hour)

I'm able to quickly accomplish this in Excel, but have no idea how to achieve the same in Smartsheet. We have a call log where a new Created row is automatically generated on submission. I'd like to create a graph that totals all calls by time, specifically the hour of the day.
In Excel I create a pivot on the Created column, group by Hour, then chart.
How would I accomplish this in Smartsheet?
Best Answer
-
Hi @sstubbs
You can get the time part of the "Created Date" value in 24-hour format with the following formula;
=TIME(RIGHT(Created@row, 8), 1)
Then you can get the "Hour" part by the following formula;
=VALUE(LEFT([24 Hour Format]@row, 2))
Then, using a metric sheet counting data grouping by hour, you can create a chart in a dashboard.π
Answers
-
Hi @sstubbs
You can get the time part of the "Created Date" value in 24-hour format with the following formula;
=TIME(RIGHT(Created@row, 8), 1)
Then you can get the "Hour" part by the following formula;
=VALUE(LEFT([24 Hour Format]@row, 2))
Then, using a metric sheet counting data grouping by hour, you can create a chart in a dashboard.π
-
@jmyzk_cloudsmart_jp Thank you for your solution, that worked.
-
Wow, your dashboard is beautiful!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!