Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to plot a duration distribution graph?

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

1 Reply
Not applicable
Author

Untitled.png