Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'd like to produce a matrix report that can show the following sample format for each week the number of active tickets for each assignment group. For example
11-Dec | 18-Dec | 25-Dec | 01-Jan | 08-Jan | 15-Jan | |
Group A | 17 | 1 | 12 | 12 | 31 | 4 |
Group B | 3 | 23 | 34 | 3 | 3 | 1 |
Group C | 20 | 27 | 5 | 67 | 6 | 1 |
The source data is a count of all active tickets for the end of a week. For example if the end of the week was Jan 15 and the data is
Ticket # | Assignment Group | Created |
1a | Group A | 01-Jan-22 |
2b | Group B | 05-Jan-22 |
3c | Group C | 29-Dec-21 |
1a | Group A | 30-Dec-21 |
2b | Group A | 31-Dec-21 |
3c | Group A | 14-Jan-22 |
Group A would have 4 active tickets
Group B and C would have 1 each.
I've also produced a calendar and table as well but have not succeeded in producing the report. Any assistance would be appreciated. Thanks all.
Solved! Go to Solution.
Hi @lke ,
Is there a completed date in your data model?How to determine whether it is active ticket?
In my experience,In my experience,If you have a completed date and check that current date is between the created date and the completed date.
You can refer to the sample pbix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @lke ,
Is there a completed date in your data model?How to determine whether it is active ticket?
In my experience,In my experience,If you have a completed date and check that current date is between the created date and the completed date.
You can refer to the sample pbix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Add a ticket close date to your source data. Read about active and inactive relationships
- Clearly define what a week means to you. From your source data it looks like your weeks start on saturday?
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
3 | |
2 | |
2 |