How can I create a widget that would show the number of RITM per month that are ''open''

[davidturgeo]

How can I create a widget that would show:

• The number of RITM per month that are ''open'', ''Pending'', ''Work in Progress''(not completed).
• Since the beginning of time.
• For a specific assignment group
• The result would be accumulating the numbers of RITM's 
  • Ex: in Jan. 3 are still opened, in Feb. 2 are still opened so it would show 5, 4 in March are still opened so it would show 9 and so on.
• Other wise, I am looking for the backlog of RITM still opened, accumulating over months.

So far I can create a report of type: time series (Column)Configured like:

Group by : None

Trend by : Created

Calendar : Standard calendar

Per : Month

Aggregation : Count

The filters are:

State ''is not one of'' (Closed complete, Closed incomplete, Closed skipped)

AND

Created ''at or after'' 01-01-2022

AND

Assignment group is ABCDEFG.

So it gives me the numbers of RITM still open per month but the accumulation over months I cannot seem to be able to do it, can someone enlighten me please ?