Weekly Running Total

[lke]

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.

[V-lianl-msft · Accepted 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.

[lbendlin]

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