Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
i need to count per DATE , the number of Client who has already call in the last 7 days
I put here a sample with only 2 dates but the calculation should works for a 7 days period per date
Her you can see that i have for the 05/01/2021 8 Callers but 4 of them has already call the 04/01/2021
So my distinct count of caller is 8 , but how to get those who called the 05 /01 and in the last 7 days ?
Thank a lot for your help
i tried with set analysis , P function but without success
Regards