Can I count the number of reasons for each reopen reason? (when the reopen is N times)
→ Reopen reason is our custom field (string type)
Now, when the each reopen reason count, it is counted last reopen reason.
For example,
| Reopened Reason (custom field) |
Total |
additional check |
change resolution |
Reproduce |
| A issue |
8 |
|
|
8
(last Reopen Reason) |
| B issue |
6 |
|
6
(last Reopen Reason) |
|
| C issue |
2 |
2
(last Reopen Reason) |
|
|
- Real Reopen Reason count → We want it!
| Reopened Reason (custom field) |
Total |
additional check |
change resolution |
Reproduce |
| A issue |
8 |
|
4 |
4 |
| B issue |
6 |
3 |
1 |
2 |
| C issue |
2 |
1 |
1 |
|
Hi @byungbuyoo,
If the field “Reopen Reason” is a single-value field, you can enable the change history import for it. Please review the eazyBI documentation page on how to do that for Jira custom fields - Import issue change history.
After that, you can define a new calculated measure that would count the number of transitions to the values in the “Reopened Reason” field. The formula could look similar to the one below:
([Measures].[Transitions to],
[Transition Field].[Reopened Reasons])
After that, you can create the table report you shared as an example. See an example below:
Best,
Roberts // support@eazybi.com
1 Like
Thank you for support!
We successfully checked it 
1 Like
