topic Re: YTD Count of Customers with zero interactions in App Development

YTD Count of Customers with zero interactions

Haarika — Mon, 21 Sep 2020 20:18:02 GMT

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 ?

Re: YTD Count of Customers with zero interactions

sunny_talwar — Tue, 22 Sep 2020 01:49:59 GMT

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

Re: YTD Count of Customers with zero interactions

sunny_talwar — Tue, 22 Sep 2020 01:52:24 GMT

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

Re: YTD Count of Customers with zero interactions

Haarika — Tue, 22 Sep 2020 18:50:57 GMT

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