Skip to main content

Hi there,

I'm trying to build an histogram that shows the cycle times.

Everything seems to work just fine, but when I compare the N. of occurences it doesn't match the number that I need. I read in the documentation that it uses the cases as occurences, insted I need a certain type of activity.

 

If instead I build a column chart with the Cycle Times as dimension and occurences as KPI, numbers are correct, but I can't find a way to display the cycle times in a fancy way like the histogram, since in the column chart are displayed the single values for every instance, that I can round, but they are not the 10 ranges that I have with the histogram.

 

I need or to customize the number of occurences in the histogram, so it can match, or customize the dimension axis of the column chart, in a way that is similar to the histogram.

 

Thank you very much!

Hi Federico,

 

you can try the following with a standard OLAP Bar Chart table:

 

In your Dimension use a logic like this:

CASE WHEN ROUND(KPI("Cycle Time Total")) BETWEEN 0 AND 25 THEN '0 - 25'

WHEN ROUND(KPI("Cycle Time Total")) BETWEEN 26 AND 50 THEN '26 - 50'

WHEN ROUND(KPI("Cycle Time Total")) > 50 THEN '>50'

END

 

And in your KPI just use a case count.

The result is a bar chart that looks like a histogram.

 

Regards,

Dennis


Hi Federico,

 

you can try the following with a standard OLAP Bar Chart table:

 

In your Dimension use a logic like this:

CASE WHEN ROUND(KPI("Cycle Time Total")) BETWEEN 0 AND 25 THEN '0 - 25'

WHEN ROUND(KPI("Cycle Time Total")) BETWEEN 26 AND 50 THEN '26 - 50'

WHEN ROUND(KPI("Cycle Time Total")) > 50 THEN '>50'

END

 

And in your KPI just use a case count.

The result is a bar chart that looks like a histogram.

 

Regards,

Dennis

I did it like this, not very scalable but it still works.

 

Thanks!


Reply