Hello community,
Short version
I am consistently seeing a different number of (work)days in transition status for individual issues than what I calculate from the History in Jira. How does eazyBI calculate these values? Anything I may be missing?
Longer explanation
I’m trying to create an average cycle time report by component that EXCLUDES the backlog and done statuses, and an average lead time report by component that INCLUDES backlog but NOT done. I’ve created two new Transition Status calculated members to do this, but I am still very new to MDX.
On the surface the data look approximately correct, but when I try to spot check using Drill Through Issue the values there don’t match up to the History values for work items in Jira. They’re usually off by about 2 - 10 days if I look at working days, and more than that if I look at calendar days.
Thanks for your help!