8 Replies Latest reply: Sep 18, 2013 4:14 AM by Abey Chandy RSS

    How do I display records created by hour?

      Hi,

       

      Have a table with helpdesk records created over time. The field "CreatedDateTime" displays when the records were created. I have loaded a new field called "RoundedCreatedTime" that only displays the actual time and also rounds the time to the closest hour.

       

      I would like to create a line chart that shows a trend of when most of the helpdesk records are created by hour, during a day. If I create a chart with dimension "RoundedCreatedTime", and expression Count(Helpdesk ID), the chart is not displayed correctly.

       

      I have pretty much run out of ideas. Can someone put some light on this?

       

      Thanks,

      Mikael