4 Replies Latest reply on Sep 7, 2016 7:46 AM by tancrde.fde

# Problem with new vs returning clients

Hi,

I am struggling to understand why the sum of my new and returning clients gives me a higher number than the total number of clients.

My calculated field for 'client type' is the following:

IF [Dat Ach] = {FIXED [Id Client] : MIN([Dat Ach])} THEN "New"

ELSEIF  [Dat Ach] > {FIXED [Id Client] : MIN([Dat Ach])} THEN "Old"

END

See screenshot:

With countd(Id_client)

With 'client type' calc added to row:

Thank you

• ###### 1. Re: Problem with new vs returning clients

Hi, since i imagine you have "Id client" with multiple dates, you will have clients who are both classified as "new" and "old" for different dates according to your lod calc.

Maybe this photo can show what could be happening for a single client id. Hopefully this helps.

• ###### 2. Re: Problem with new vs returning clients

Hi,

Thanks. So basically, the clients that buy more than once during the period of the VizLoD are double counted. So how can I specify that I want to look at the month/year interval for new vs old users? I have tried to add  [DateMonth] to the FIXED LoD but to no avail...

• ###### 3. Re: Problem with new vs returning clients

You have to decide what time period you want to look at to appoint a client as either new or old.

If you're looking at month, then you could use...

if

month({ FIXED [Client id] : MIN([Date atch]) }) = MONTH([Date atch]) and year({ FIXED [Client id] : MIN([Date atch]) }) = year([Date atch]) then "New"

else "Old" end

If you're looking at year, you would just need...

if

year({ FIXED [Client id] : MIN([Date atch]) }) = year([Date atch]) then "New"

else "Old" end

• ###### 4. Re: Problem with new vs returning clients

Amazing, thank you.