Hi, I could not find an answer to this question but if there is already a topic discussing this issue I apologize.
I'm trying to track how many 'active minutes' each user spends on my site and accomplish this what I currently do is:
-Query my events table for unique user count per minute. This give me a visualization that represents which users did an action on the site for every minute. This is great, but now I want to aggregate this information on a daily basis and see how many minutes each user used the site for. Is there a way to feed my current visuazliation into another to aggregate a whole day?
Here is a screenshot of my visualization with unique user events per minute. Each color represents a different user and if they are present in a certain timestamp it means they made an action in that one minute interval.
Is this question clear? Should I provide more information?