Cumulative Monthly User Count in Report

[Jacobb]

Hello,
I'm working on a report that needs to display the total number of users in our database, grouped by month. The goal is to show a cumulative count of users over time.

For example, if we have a total of 100 users:

• 50 were created in January
• 30 in February
• 20 in March

Then the report should show:

• January: 50 users
• February: 80 users (50 + 30)
• March: 100 users (80 + 20)

Complex expressions dont allow the addition of the counted records.
Is there an alternative approach or workaround to achieve this result?
Any help or suggestions would be greatly appreciated.
Thank you.

[victor]

This is possible, but within individual reports:
Report 1: only January in the filter.
Report 2: from January to February in the filter.
Report 3: from January to March in the filter.

You have 12 reports in a year (where the total at the end of the report will be a cumulative total). You can continue in this way, but I don't understand why you need such a report. If you explain your ultimate goal in more detail, maybe someone from the community can suggest something better.

[Jacobb]

Hello victor,
thank you for the response.
The end goal is too create a report which shows for each month how many users were created, deleted and the number of current users in our database for each month.
So far i've been able to achieve the first two by creating two separate grid reports of created users per month and deleted user per month but I'm having trouble with the commulative current users for each month as I would link to know if it's possibile to achieve it by creating just one report otherwise I would just have to create a report for each month.
Thank you.

[victor]

You can see a deleted User, as well as a deleted record, in phpMyAdmin (or similar programs), not through the UI. If I were you, instead of deleting users, I would simply mark them as Inactive. And then this information would be available through the UI. For example:

- Let's create the First Grid Report by Active Users (add the Is Active -> Yes field to the filter):



- Create a Second Report on Inactive Users (add the Is Active -> No field to the filter):



- And we create a Joint Grid Report that combines them: https://docs.espocrm.com/user-guide/...t-grid-reports


We get the result:

[Jacobb]

Hello victor,
thank you for the reponse.
We actually implemented the users (active and inactive) in a similar way as you described, we rather have a separate entity that tracks deleted users.
What we need is a third column coloumn that shows the actual concurrent users. Using your report as an example we would have august '22 at 3 september '22 at 4 as it's the sum of the concurrent users in august and september. And on January '25 we would have 12 as our number of concurrent users. One big issue with creating multiple reports per month is we have users that were created as far back as 2021, that would mean to create 24 reports for just 2021 and 22