
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to display a 24 hour timeline chart?
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Don't worry i worked it out...
I was extremely stupidly missing some commas in the load inline part of the script

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Don't worry i worked it out...
I was extremely stupidly missing some commas in the load inline part of the script


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hour, Hour_Min, Hour_Range
0, 00:00, 00:00-01:00
1, 01:00, 01:00-02:00
2, 02:00, 02:00-03:00
3, 03:00, 03:00-04:00
4, 04:00, 04:00-05:00
5, 05:00, 05:00-06:00
6, 06:00, 06:00-07:00
7, 07:00, 07:00-08:00
8, 08:00, 08:00-09:00
9, 09:00, 09:00-10:00
10, 10:00, 10:00-11:00
11, 11:00, 11:00-12:00
12, 12:00, 12:00-13:00
13, 13:00, 13:00-14:00
14, 14:00, 14:00-15:00
15, 15:00, 15:00-16:00
16, 16:00, 16:00-17:00
17, 17:00, 17:00-18:00
18, 18:00, 18:00-19:00
19, 19:00, 19:00-20:00
20, 20:00, 20:00-21:00
21, 21:00, 21:00-22:00
22, 22:00, 22:00-23:00
23, 23:00, 23:00-00:00
];

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes i spotted that too - thanks for replying

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Haymarketpaul,
I was wondering if you could share to me how was that you fixing your script to solve the problem. I have a similar doubt that how link time and show time charts, It could be useful for my case.
Thank in advanced
Luis
