How to Count Distinct Visits Once in a Month to month

[#1]

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.

[jonathandienst]

In a table with month as a dimension, you just need

     Count(DISTINCT CustomerCode)

Or have I not properly understood your requirement?

Jonathan

[pokassov]

Hi!

= sum(aggr(count( distinct MonthName(Date)), CustomerCode ))

[#4]

Hi Jonathan,

you haven't Understood my Requirement

[#5]

Hi,

Your expression Disable all my Values and Shows nothing on my Straight Table.

[PrashantSangle]

Hi,

try

Aggr(Count(distinct CustomerCode),MonthName(Date))

Create MonthYear field which will make easier to write code

Regards

[awhitfield]

Hi Thabiso,

check out the attached for some pointers: !

[rubenmarin]

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))

[#9]

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.