Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to calculate visits a Guy made to you in a Month to month.
E.g
If i visit you 20 times in a Month the answer should be 1 visit, and in a year it should be 12 visits
Please advise, herewith my Script.
=sum(aggr(count(DISTINCT Date),CustomerCode,Date))- sum(aggr(count(DISTINCT Date),CustomerCode,Date))+1
Regards.
In a table with month as a dimension, you just need
Count(DISTINCT CustomerCode)
Or have I not properly understood your requirement?
Jonathan
Hi!
= sum(aggr(count( distinct MonthName(Date)), CustomerCode ))
Hi Jonathan,
you haven't Understood my Requirement
Hi,
Your expression Disable all my Values and Shows nothing on my Straight Table.
Hi,
try
Aggr(Count(distinct CustomerCode),MonthName(Date))
Create MonthYear field which will make easier to write code
Regards
Hi Thabiso,
check out the attached for some pointers: !
Agree with max dreamer, just to comment that the Aggr() should be inside a Sum(), if you use MonthYear fields as suggested it can be:
Sum(Aggr(Count(distinct CustomerCode), MonthYear))
Hi,
i got it covered i just putted the Month Column, then it worked like a Magic.
Thank you all, you'r e the best in Support.