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
| CLIENT | 04/01/2021 | 05/01/2021 |
| 3102078 | 1 | 3 |
| 3706430 | | 4 |
| 3532396 | 1 | 3 |
| 3307200 | 1 | 3 |
| 238988 | 1 | 2 |
| 405407 | | 3 |
| 306068 | | 3 |
| 303518 | 3 | |
| 230331 | | 1 |
| 274913 | 3 | |
| 817600 | 3 | |
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
