How to add up a column and get the 85th percentile

Questions & Answers
1

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.

cycletime
cycletime1340×918 268 KB

2

Hi, @sangood

Welcom to the eazyBI community. There are no silly questions!

I’m here to help.

To find an 85th percentile of Cycle time, you can define a new calculated measure (under the Measures) using function Percentile and VisibleRowSet.

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.

Barchart with line
Barchart with line1762×848 74.9 KB

If you want to see the results vertically, please also choose that. See the picture

vertical bar chart
vertical bar chart1754×872 56.7 KB

Kindly,
Ilze support@eazybi.com