YTD Count of Customers with zero interactions

[Haarika]

Hello all,

I need to display the YTD count of customers who havent been contacted / interacted even once in the current year. And this metric needs to be time dependent i.e. when Month Year is selected from the filter then the metric value should change accordingly. 

Below expression throws an error when i incorporate the Month Year condition in set modifier saying that error in set modifier adhoc element list: ',' or ')' expected

count(distinct {<[Flag]={'1'},[Month Year] = {"<=$(=MaxString([Month Year]))"},[%KEY_Customer] = {"=count(distinct {<[Month Year] = {"<=$(=MaxString([Month Year]))"},[Status]={'Active'},[Party]={'1'},[Target]={'Target'}>} [Call])=0"}>} [%KEY_Customer])

@Sunny Could you please provide probable solutions to fix this error ?

[sunny_talwar · Accepted solution]

Try this @Haarika 

Count(DISTINCT {<[Flag] = {'1'}, [Month Year] = {"<=$(=MaxString([Month Year]))"}, [%KEY_Customer] = {"=Count(DISTINCT {<[Month Year] = {""<=$(=MaxString([Month Year]))""}, [Status] = {'Active'}, [Party] = {'1'},[Target] = {'Target'}>} [Call]) = 0"}>} [%KEY_Customer])

and my tag is @sunny_talwar 

[sunny_talwar]

You can also try

Count(DISTINCT {<[Flag] = {'1'}, [Month Year] = {"<=$(=MaxString([Month Year]))"}, [%KEY_Customer] = {"=Count(DISTINCT {<[Month Year] = {[<=$(=MaxString([Month Year]))]}, [Status] = {'Active'}, [Party] = {'1'},[Target] = {'Target'}>} [Call]) = 0"}>} [%KEY_Customer])

[Haarika · Accepted solution]

@sunny_talwar - This solution works. thank you for your help 🙂