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

      etc...

      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.

      Paul