How can I get 85th percentile for cycle and lead time

Hi, I am trying to get just simple cycle and lead time for all of our Jira projects but am having a hard time adjusting for the 85th percentile. I have a couple of measures I have tried and nothing seems to be working (we had another tool that did this that I can compare to see if my results are accurate). Any help would be greatly appreciated!

@Paula_Pokusa

Perhaps you could check two other community posts for a similar use-case:

Martins / eazyBI

Hi Martins,

I tried to use what is suggested in those posts but when added to my report I get essentially an error. Instead of showing a number I get “yyyy-mm-dd hh:nn:ss” not sure how to solve for that.

@Paula_Pokusa

Date format is not automatically recognized for such complex calculations.
Try manually saving the calculated measure with “integer” format.

Martins / eazyBI