Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi am having Customer ID and Application number
Scenario: A customer 'xyz' can apply to purchase a product on today for 3 times so count(Application number) for particular customer on that day is"3".
But here i need to capture information as one Customer on a particular day ,one application.
So finally i need to show customer 'xyz' Count(Application) =1
Hi,
If Whenever Customer Purchase Product then generated Application Number is same or different for day.
If it is same then Sunny's Answer work.
If not then try below,
=Count(Aggr(Count(DISTINCT [Customer ID]), Day)
Regards
May be this:
=Count(Aggr(Count(DISTINCT Application), Customer, Day)
Hi,
If Whenever Customer Purchase Product then generated Application Number is same or different for day.
If it is same then Sunny's Answer work.
If not then try below,
=Count(Aggr(Count(DISTINCT [Customer ID]), Day)
Regards
Thanks a lot sunny it works.
Awesome, I am glad I was able to help .
Thanks for taking time to mark my response as helpful, but I would also suggest closing this thread down by selecting a correct answer (and also mark other helpful answers).