I'm not sure exactly how to word this. However, i would like to have a timeseries chart that plots point in time values every minute.
I collect login and logout events for users into a system. I have a transform that calculates users currently logged in.
I want to save the value for each minute so for example at 15:01 22 users were logged in, and 15:02 24 users were logged in etc. So you can see the change in logged in users over time. These values need to be individually calculated each minute and store basically.
If anyone understands what i'm trying to achieve here, it would be great if you could offer some advice on how best to solve?