Hi, I’m fairly new to eazyBI so please forgive the question if it’s silly. I am trying to add up the column ‘Cycle Time’ and then to find the 85th percentile of that single value. Can it be done? Many thanks for any help.
Welcom to the eazyBI community. There are no silly questions!
I’m here to help.
The formula should look something like this:
Percentile( VisibleRowsSet(), [Measures].[Cycle time], 85 )
Please double-check if the Cycle time is correctly spelled in the given formula.
After creating the new measure, please use it in the report.
To see the 85th Percentile line, go to the Bar chart, choose the measure, and please select Type - Line. See the picture.
If you want to see the results vertically, please also choose that. See the picture