Hi, I am trying to build an app which counts the number of open tickets in a month. I am having trouble thinking through how to calculate cumulative remaining tickets opened. Any help or direction is appreciated.
The suggestion Stefan put forward assumes that there is a "date_closed" for all records, but there are not. I tried using your example but I am facing an issue with open cases with no closed dates being unaccounted for (showing up in a gray bar in my chart).
I think I am closer to solving the problem. A few issues to point out, 1. I added this line as you recommended, but now I have thousands more records than I had before, does Alt() function make duplicate records, I should have a total of 3,800 open cases, but the total has now jumped up to 322,777. Also, it is interesting that the total of "open" records in April has doubled than what I was expecting to see in the chart, it should be 3,800 and now it has jump up to 6.6k. Would you be able to take a look at this revised app?