I would like to create a Histogram with Percentiles, Mode, Mean and Median.
I used the forum thread below to create the histogram:
Good morning guys. My first question here on the forum.
I would like to build a Histogram with the Cycle Time of my Downstream Stream. This report will have the x axis with the days of the Cycle Time and the y axis will have the issue number with the same Cycle Time.
We will have a variable with the downstream flow.
I tried to use Age interval and Resolution interval dimension, but it was not possible as it adds the opening date to the resolution date.
Can anyone help me?
I tried to use the topic below to create the Percentiles, but it didn’t work, as shown in the image:
Hello, I am trying to build a Monte Carlo style chart based off of Resolution Interval dimension and using Issues resolved measure. It mostly works, but I get an unexpected result. I am trying to show a vertical line at the range matching 90th percentile. I am getting 2 hits on my CASE, when I expect only one. For reference, my 90th percentile value is 124 so I expect the line to land between 120 - 129 range.
– left part of range is less than percentile…
– extract the firs…
The correct value of the 50th percentile is 5.
Could you please send the formula you use for calculating the percentile?
Here’s the formula:
[Measures].[Issue resolution date],
CASE WHEN [Measures].[Issues resolved] > 0
NonZero(([Measures].[Days in transition status],
[Transition Status].[Fluxo Customer lead time],
, 50 )
I’m sorry, I can’t see where the problem could be quite yet. Could you please send exported report definition (
Create reports) to email@example.com? Add the link to this community post and notify that you discussed this with Lauma.