Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table:
EventID : Duration (in minutes)
1 : 3
2 : 3
3 : 2
4 : 2
5 : 8
I need to create a graph that displays a "bucket" of Durations in the x axis and the count of Events within that bucket, like below
Duration : Number of Events
0 - 5 : 4
5 - 10 : 1
10 - 20 : 0
more than 20 : 0
I was pretty sure I needed a calculated dimension of aggr(count(EventID),Duration), but that didn't work...
Any ideas?
Thanks!!