New Customer Count Expression

[fazunus]

Dear All,

I am working on creating a new customer count expression based on the  customers who were created in selected period.I  have activity the table with the contact date(activity date) and the customer table with the customer creation date.

I would like to have the table output as attached in the excel sheet.

[Vegar · Accepted solution]

Try something like this.

= count({< 
         [creation date]= {">=$(=min([activity date]))<=$(=max([activity date]))"}
        > } distinct CustomerID)

You might want to expand the modifier to cancel all selection in  other period dimension such as [Year] , [Month], [Week]

= count({< 
    [creation date]= {">=$(=min([activity date]))<=$(=max([activity date]))"},
    [Creation Year]=,
    [Creation Month]=,
    [Creation Week]=
    >} distinct CustomerID)

[fazunus]

Dear Vegar,

Thanks for the swift response.Its working perfectly fine.

Thanks again bro.
Regards