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
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: