Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
14 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
11 | |
3 | |
3 | |
3 | |
2 |