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.