topic Re: Set Analysis with Aggregate - Escape Filters in App Development

Set Analysis with Aggregate - Escape Filters

flottmen — Tue, 12 Dec 2017 19:44:57 GMT

I have written the following expression:

Count(TOTAL DISTINCT {$<Affiliate={"=$(vDeliveredCount)>=250"}>} Affiliate)

The vDeliveredCount variable referenced evaluates to this: Count({$<DeliveryStatus={'D','O'}>} LeadId)

Basically, the idea here is to count Affiliates that have at least 250 delivered transactions. This seems to be working as expected. However, I need this count to be calculated the same no matter what filters have been set by the user. Selecting one Affiliate in my table always reduces this count to 1. I have tried both of the following in an attempt to escape the Affiliate filter:

Count(TOTAL DISTINCT {$<Affiliate=, Affiliate={"=$(vDeliveredCount)>=250"}>} Affiliate)

Count(TOTAL DISTINCT {$<Affiliate={"=$(vDeliveredCount)>=250"}, Affiliate=>} Affiliate)

Neither seem to generate the required result. It seems like the second instance of the Affiliate set analysis simply replaces the first rather than both being evaluated.

Is there some syntax I can use to achieve the desired outcome?

Re: Set Analysis with Aggregate - Escape Filters

sunny_talwar — Tue, 12 Dec 2017 19:51:58 GMT

Change your variable to this

Count({1<DeliveryStatus={'D','O'}>} LeadId)

Re: Set Analysis with Aggregate - Escape Filters

sunny_talwar — Tue, 12 Dec 2017 19:52:49 GMT

Or this

Count({<DeliveryStatus={'D','O'}, Affiliate>} LeadId)

Re: Set Analysis with Aggregate - Escape Filters

flottmen — Tue, 12 Dec 2017 20:07:50 GMT

That did it. Totally forgot to escape the filter in the count. Thanks, Sunny.

Re: Set Analysis with Aggregate - Escape Filters

sunny_talwar — Tue, 12 Dec 2017 20:08:49 GMT

No problem at all