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

sstubbs

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?

jmyzk_cloudsmart_jp

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.😁

Smartsheet

https://app.smartsheet.com/b/publish?EQBCT=9561450106084517a0027e6fd2b37b09

jmyzk_cloudsmart_jp

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.😁

Smartsheet

https://app.smartsheet.com/b/publish?EQBCT=9561450106084517a0027e6fd2b37b09

sstubbs

@jmyzk_cloudsmart_jp Thank you for your solution, that worked.

jmyzk_cloudsmart_jp

@sstubbs

Wow, your dashboard is beautiful!