Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Don't worry i worked it out...
I was extremely stupidly missing some commas in the load inline part of the script
Don't worry i worked it out...
I was extremely stupidly missing some commas in the load inline part of the script
yes i spotted that too - thanks for replying
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