Counting new accounts month on month

building reports
1

Hello all,

We have some sales data of accounts who traded with us for a 6-month date range 2024 vs 2025. I can do a =count([acc no];distinct ) and get a unique monthly count of accounts who traded. And then do a 2025 accs - 2024 accs to show weather March 2025 was up or down on March 2024 for example.
However, what we need is to identify the count of how many new accounts there are each month, i.e. accounts that did not trade in the previous month. so essentially state how many incremental customers we have gained. I’ve looked through the list of functions in 4.3 but nothings jumping out at me. Does anyone know if there is a way of doing it, please? Thank you.

2

So, an example would be
march 25 traded accounts:
abc1
abc2
abc3
abc4
April 2025 traded accounts:
abc1
abc2
abc3
abc4
abc5

March 25 = 4
april 25 = 5

New customer value = 1

3

Just out of curiosity, how do you want to handle traded accounts that drop off the next month? this isn’t a new account, it is a loss of an account. Does it matter that the same account is in the current and previous months or are you just looking for a total difference?

4

Can’t you just take the account number as a dimension and then the minimum order date for each account number? You might need to do some dates formatting jiggery-pokery to get the month, but logically it should work.