See new debtors per month

[#1]

Hello everyone,

I want to create a graph chart which shows the amount of new debtors per month.

I'm using logfiles as data and these logfiles are created each day. Every day is a new logfile.

The problem I'm running into is that I want to count each debtor only the first time they got logged.

I can't use a distinct count, because if I show the amount of debtors per month, then the debtors who were

online in february and march are counted as 1 in both months. I want it that when someone's first logged event is february, then the only month that debtor is counted in is february. If he is also online in march, he shouldnt be counted.

I hope someone can help me!

Thanks in advance

[vinieme12]

use Autonumber() this will assign numeric values for each instance , but you must sort the data by date

so for example if Debtor A was in the log file for Jan,feb,Mar, the entry for Jan will have autonumber value 1,2,3 respectively

So using set analysis filter out records with Autonumber value as {1}

[migueldelval]

Hi Ivo,

I think taht you need to make a link table with debtors and make a flag if it´s new or not.

Could you attach a data sample to understnad better your requirement?

Regards

Miguel del Valle

[#4]

Hey Miguel,

I unfortunately cant share the data i'm using, but I can try something with assigning a new or not to each debtor.

Thank You