How to plot a duration distribution graph?

Thu, 17 Dec 2015 04:16:30 GMT

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!!

Re: How to plot a duration distribution graph?

Thu, 17 Dec 2015 13:33:27 GMT