Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (2)
1 Reply
Not applicable

Re: How to plot a duration distribution graph?

Untitled.png

Community Browser