Counting in progress issues

Questions & Answers
1

Hi Team

I am making a report where per sprint , i want to know each day how many issues were in progress.
Somthing like below
Sprint 1
Day1 —10
Day2- 8
Day3–8
Day4–5
Day10-1

I can’t get the count of issues in progress on any given day , can you help ?

Thanks and regards
Uttam

2

Hi @Uttam ,
You can use issue historical measures and dimensions to show how many issues were in the progress status at the end of the day on a certain date.
For that, you can use this tuple:

([Measures].[Issues history],
[Transition Status].[In Progress])

But this won’t count issues that transitioned from the in progress status. If you want to count on the same day also issues that transitioned from in progress status (were during the day, but at the end are in different status), then you can use this tuple:

([Measures].[Transitions from status issues count],
[Transition Status].[In Progress])

And you can sum both together to see all issues:

([Measures].[Issues history],
[Transition Status].[In Progress])
+
([Measures].[Transitions from status issues count],
[Transition Status].[In Progress])

best,
Gerda // support@eazybi.com