3 Replies Latest reply: Oct 3, 2011 6:46 AM by Paul Nockolds RSS

    How to display a 24 hour timeline chart?

    Paul Nockolds

      Hi there


      I have some data that details the date and time a client email was read.


      I would like to create a timeline chart where the x-axis spans 24 hours and the y-axis is a count of uid so i can display at what time of day most emails are read by our clients.


      So the x-axis would have increments like

      00:00 - 01:00

      01:00 - 02:00

      02:00 - 03:00


      23:00 - 00:00


      I would still like to display each increment regardless of whether data exists for that timeframe.


      I have tried a couple of approaches to get this to work which you will see in the attached qvw on the main tab but i am struggling to make sense of what i am doing wrong?  The data in my hour field just looks weird?


      For data sensitivty reasons i have removed the actual email address data from the attached qvw.  I have also commented out parts of the script that were unrelated to make it easier for someone to view and hopefully help.


      Any help/pointers greatly appreciated.