1 Reply Latest reply: Dec 17, 2015 8:33 AM by ramu yeluru RSS

    How to plot a duration distribution graph?

    Paulo Lindoso

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