Forum Discussion
Filterable Unresolved Issues Chart for JIRA data
Hi cearly65 ,
Please try the measure.
Open tickets = CALCULATE ( DISTINCTCOUNT ( 'Jiradata'[Issue Key] ), FILTER ( 'Jiradata', 'Jiradata'[Created].[Date] <= MAX ( 'Calendar'[Date] ) && ( 'Jiradata'[Resolved].[Date] >= MAX ( 'Calendar'[Date] ) || Jiradata[Resolved] = BLANK () ) ) )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserPlease share example data from all tables.
Please share as a table and not a screen shot so we can import and use it to create a demo solution.
Also share a example desire output with clear decsription of how unresolved and resolved tickers are determined.
And if a ttick is raised on 8/5/2021 and resolved on 2/5/2022. How do you want it displayed on 11/5/2021. It was unresolved then but it is resolved now.
See sample data below. I am essentially trying to create a chart that shows the count of unresolved issues (sum of created minus sum of resolved) for each day over time to see if we're trending towards more issues being created than we can resolve or trending towards resolving more than new ones are being created. In your specific example the chart would count the ticket towards the unresolved total for 11/5/2021, then would no longer count it as unresolved in the total for 2/6/2022.
Once I have that chart working then I want to be able to filter it by different criteria in the jira data. For example filtering Document vs Procedure issue types to see if we're resolving either type faster than new ones are being created.
| Issue Key | Issue Type | Priority | Status Category | Assignee | Program | Created | Updated | Due Date | Resolved |
| RSD-9 | Document | Not Prioritized | Done | Employee K | 11/9/2020 11:17 | 12/9/2021 8:09 | 5/28/2021 0:00 | ||
| RSD-567 | Document | Not Prioritized | In Progress | Employee G | 11/17/2020 10:56 | 4/25/2022 14:30 | 5/28/2021 0:00 | ||
| RSD-568 | Document | Critical | Done | Employee A | 11/17/2020 11:05 | 4/15/2022 9:04 | 5/28/2021 0:00 | ||
| RSD-569 | Document | High | In Progress | Employee G | 11/17/2020 11:35 | 4/21/2022 19:53 | 5/28/2021 0:00 | ||
| RSD-664 | Document | Not Prioritized | In Progress | Employee G | 2/10/2021 8:05 | 11/23/2021 10:59 | 8/27/2021 6:28 | ||
| RSD-665 | Document | Not Prioritized | In Progress | Employee J | 2/10/2021 8:30 | 4/26/2022 8:43 | |||
| RSD-673 | Document | High | In Progress | Employee G | 2/24/2021 7:50 | 3/28/2022 15:34 | 3/24/2022 0:00 | ||
| RSD-674 | Document | Not Prioritized | In Progress | Employee G | 2/24/2021 8:22 | 4/20/2022 16:23 | 8/27/2021 6:29 | ||
| RSD-676 | Document | Critical | In Progress | Employee G | 3/1/2021 17:08 | 4/28/2022 7:21 | |||
| RSD-680 | Document | Not Prioritized | In Progress | Employee J | Program AB | 3/10/2021 15:21 | 5/4/2022 16:35 | ||
| RSD-683 | Document | Not Prioritized | In Progress | Employee D | 3/16/2021 16:04 | 3/21/2022 12:34 | |||
| RSD-684 | Document | Not Prioritized | In Progress | Employee D | 3/17/2021 6:58 | 4/27/2022 11:04 | |||
| RSD-688 | Document | High | In Progress | Employee G | 3/19/2021 18:47 | 4/12/2022 17:11 | |||
| RSD-689 | Document | Medium | Done | Employee A | 3/19/2021 18:53 | 4/15/2022 9:06 | 8/27/2021 6:30 | ||
| RSD-711 | Document | Medium | In Progress | Employee J | 4/6/2021 9:15 | 5/2/2022 14:41 | 6/1/2021 0:00 | 8/27/2021 6:32 | |
| RSD-747 | Procedure | Medium | In Progress | Employee D | Program AB | 5/6/2021 16:35 | 1/31/2022 14:48 | ||
| RSD-749 | Procedure | In Progress | Employee D | Program B | 5/11/2021 17:47 | 4/27/2022 7:22 | |||
| RSD-750 | Procedure | Done | Employee G | Program AB | 5/11/2021 17:47 | 12/23/2021 13:18 | 10/28/2021 12:12 | ||
| RSD-751 | Procedure | Done | Employee D | Program B | 5/11/2021 17:47 | 4/4/2022 12:48 | 1/31/2022 16:47 | ||
| RSD-752 | Procedure | Done | Employee D | Program AB | 5/11/2021 17:47 | 3/8/2022 8:36 | 12/29/2021 17:30 | ||
| RSD-753 | Procedure | Done | Employee D | Program AB | 5/11/2021 17:47 | 4/4/2022 12:48 | 1/31/2022 16:55 | ||
| RSD-754 | Procedure | Done | Employee G | Program B | 5/11/2021 17:47 | 3/7/2022 10:17 | 10/28/2021 12:30 | ||
| RSD-755 | Procedure | Done | Employee G | Program B | 5/11/2021 17:47 | 3/8/2022 8:23 | 10/28/2021 10:09 | ||
| RSD-756 | Procedure | Done | Employee D | Program AB | 5/11/2021 17:47 | 2/2/2022 14:51 | 1/13/2022 17:49 | ||
| RSD-757 | Procedure | In Progress | Employee D | Program AB | 5/11/2021 17:47 | 3/8/2022 9:43 | |||
| RSD-758 | Procedure | Done | Employee G | Program AB | 5/11/2021 17:47 | 3/8/2022 8:17 | 11/22/2021 14:29 | ||
| RSD-759 | Procedure | Done | Employee G | Program AB | 5/11/2021 17:47 | 3/8/2022 8:42 | 11/8/2021 10:09 | ||
| RSD-760 | Procedure | Done | Employee H | Program AB | 5/11/2021 17:47 | 4/25/2022 22:09 | 3/11/2022 9:12 | ||
| RSD-761 | Procedure | In Progress | Employee G | Program B | 5/11/2021 17:47 | 8/31/2021 12:07 | |||
| RSD-762 | Procedure | Done | Employee G | Program B | 5/11/2021 17:47 | 5/3/2022 10:33 | 5/3/2022 10:21 | ||
| RSD-763 | Procedure | Done | Employee D | Program B | 5/11/2021 17:47 | 5/2/2022 12:09 | 12/29/2021 15:20 |