I have a list of event times with associated users.
I want to make a graph which plots per minute the number of users with each count category of events (1,2,3,4,5+).
The result would be a graph like this, with 5 levels per minute.
I am trying a sample test now, but the actual data is huge (between 300k-800k).
One approach is to make a big auxiliary table, for every minute (m), and rows of users (*n), and count events in that minute for that user, and then form the 5 summary columns.
But this is huge, and seems overly explicit.
Any ideas on a better (formulaic) solution?
(And VBA may be the best idea, but I don't know that domain!)
And maybe this is just too big for exel without VBA, and I should do externally and import the results for plotting!
I want to make a graph which plots per minute the number of users with each count category of events (1,2,3,4,5+).
The result would be a graph like this, with 5 levels per minute.
I am trying a sample test now, but the actual data is huge (between 300k-800k).
One approach is to make a big auxiliary table, for every minute (m), and rows of users (*n), and count events in that minute for that user, and then form the 5 summary columns.
But this is huge, and seems overly explicit.
Any ideas on a better (formulaic) solution?
(And VBA may be the best idea, but I don't know that domain!)
And maybe this is just too big for exel without VBA, and I should do externally and import the results for plotting!