3 Replies Latest reply on Jan 11, 2019 4:18 AM by Prasana Uthayakumar

    Plotting Time (Continuous) against Grand Total (Analytics)

    Prasana Uthayakumar



      I recently posted this thread: Counting 'Active' Sessions using Start Time and End Time which thanks to Norbert Maijoor and sajad.bhat's help, I've managed to display the total count of sessions against any specific time.

      I've managed to re-create this work using the P1. Time Parameter to give me the total of entries which fall within that window.


      Do you know if there is a way in which I can plot the 'Grand Total' against Time as a continuous dimension (ie not D1 Start Time or D2 Stop time). I would like to plot time in increments of seconds against a full day. The data I'm working with has over 1.2 million entries over months, so I've attached a very small sample which covers a morning's worth of data! I've attached a packaged workbook in Version 2018.3.2. I've also attached the data I worked with.


      Thanks in advance - let me know if you have any questions or if I've missed something out. Thanks again!


      Kind regards,