I have a report showing Created vs Closed cases. I'm using the field / event = Created.,Closed.
This report shows the last 90 days and is summarized by week.
Now I want to also show the total of opened cases per day, in the same report, using the delta of created vs closed. Meaning - if on the first day of the report (90 days ago) we had 300 opened cases, and on that day we had 40 new cases and we closed 20 existing cases, then on the second day of the report (89 days ago) the total will be 320 opened cases.
I think that maybe a formula can help me on this, but I don't know how to use it.
Can anyone help me on this matter? Thank you!