Hi everyone, I’m trying to complete a report where is requested to view how long an issue remained in a specific status (“In review”).
Consider that this kind of issue follow a workflow where the first status is “Submitted” and the next one is “In review” (and no others) so all the issue must transit from “In review” to proceed.
I don’t understand why some cells are empty as all the listed issues have passed from “In review” status. I attached an example.
Can you help me?
Thank you,
Emiliano
Hi @emiliano
Welcome to the Community! 
Do the values show up if you remove the Priority dimension from the Page filters?
It could be the case that the issue has a different priority than the one you have selected in the filter.
Best regards,
Nauris
Hey Nauris!
Thinking on your feedback, could it be the case that when the issue was in that transition status, the priority was different?
Because now the priority corresponds to the one filtered but I checked that in the past priority was different.
Thank you,
Emiliano
Hi @emiliano
Your assumptions are correct! The historical values of Priority field are also imported into eazyBI and, when using historical measures (for example, “Days in transitions status”) the Priority dimension will filter by the historical priorities and not by the current ones.
Here, you can define a new JavaScript calculated custom field in the Advanced settings and call it “Current Priority”.
Please check out this Community ticket where I’ve described how to define it: Transition to status issue count by current issue Priority - #2 by nauris.malitis
Let me know if this works as expected!
Best regards,
Nauris