Counting issue from string value field

[Kaviraj]

Greetings,

I just want to add one field as Reopened Ticket Count on monthly wise.

For that, i’m referring one field called “IsReopened” contains values of Yes/No/none(in Some cases)
So, I was trying to create one user defined calculated member

But result showing 0 for all months , Actual result should be 4 in Apr and so on.
Thanks for your help !!!

[zane.baranovska]

Hi @Kaviraj,

Issue property “Issue IsReopened” works only when you have individual issues on rows; issue property follows the issue and can not work without it. When an issue is not in the report, then the value for the issues property also is not available in the report. Check out the presentation “Jira Admin’s Journey to eazyBI” by my colleague Gerda where she explains what properties are and how those work in eazyBI: Training videos on specific topics

The calculation “Reopen Count” is based on issue property “Issue IsReopened” and shows zero for each Time period because there are no individual issues and no property “Issue IsReopened”.
You might want to update the formula for “Reopened count” and order the calculation to go through individual issues and check the property value.

Count(
  --iterate through all issues that has property IsReopened set to Yes
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    [Measures].[Issue IsReopened] ="Yes" AND
    --measure to get report context
    --transition from status represent issue by date when issue entered any To Do status
    ([Measures].[Transitions to status],
    [Transition Status.Category].[To Do]) > 0
  )
)

Check out also those Community posts on how to get a count of reopened issues:

Find "reopened" issues

Hi, to get all issues having transitioned to “reopen” statuses, you may use “Transition” dimension together with a measure “Transitions to status issues count” (Measures > Default members > Distinct issues count). In “Transition” dimension, create a calculated member, aggregating all transitions that clear issue resolution. Then either select this “Transition” member in rows and the measure “Transitions to status issues count” in columns, or create a measure with a tuple (and add Time Defaul…

How to count issues that had ever been reopened

Hi @liu.jingjing, To see which issues have been Reopened, you need to use Issue history change measures . There are two ways how you can check if the issue was Reopened. 1.If you have a specific status for reopened issues, then by using that you can create this calculated measure in Measure dimension that checks issues that have been transitioned to it: ( [Transition Status].[Reopened], [Measures].[Transitions to status issues count] ) 2.Or if you count all issues that hav…

Best,
Zane / support@eazyBI.com