How to calculate how many issues created this year have been turn to the status Expertise

Questions & Answers
1

Hello,

I would like to count at least for the current year how many of these created issues have been turned into the status Expertise.

Thanks for your recommandations,

2

Hi @Sylvie,

Thanks for posting your question!

To count issues that transitioned to the status “Expertise” this year, you can use the “Transitions to status issues count” measure together with the Transition Status dimension.

Steps:

  1. Add the Transition Status dimension to Rows, select the “Transition Status” level member.

  2. Add the Transition Status dimension to Pages to filter by a specific transition status (e.g., “Expertise”)

  3. Add the Time dimension to Pages and filter by the “Current year”

  4. Add the measure “Transitions to status issues count”

Here is an example of my report before I have filtered by a specific transition status:

1602×1076 104 KB

I hope this helps!

Best,
Marita from support@eazybi.com