topic Re: Set analysis and wildmatch error in Integration, Extension & APIs

Set analysis and wildmatch error

antupe — Tue, 14 Jun 2022 10:18:06 GMT

I have the following formula in a text box:

Count(distinct{<CMPType={"*PERMANENT*"}, [OpenCampaing]={SI}>}Campaing)

This is to count the number of campaigns which are permanent campaigns (CMPType={"*PERMANENT*"}) and that are open (active). *PERMANENT* is used because PERMANENT is not a CMPType itself, but all of the campaigns that are permanent include the word permanent, eg 'QUALITY PERMANENT'

It works perfectly fine with all the selections like ID or date, except when I select a particular CMPType, where the total value appears.

Any ideas why? Thanks

Re: Set analysis and wildmatch error

Or — Tue, 14 Jun 2022 10:28:28 GMT

When you apply a specific selection to a field in set analysis, it will always be applied, even if it overrides the existing selection on that field. So, no matter what you select in the CMPType field, you will always view the *PERMANENT* values for that field in this formula.

Re: Set analysis and wildmatch error

antupe — Tue, 14 Jun 2022 10:35:56 GMT

Thanks! I did not know that. So do you have any suggestion of how I could manage to count the number of permanent campaigns even if a CMPType selection is active?

Re: Set analysis and wildmatch error

agigliotti — Tue, 14 Jun 2022 10:38:00 GMT

Hi @antupe ,

You should use the below expression:

Count(distinct{<CMPType *= {"*PERMANENT*"}, [OpenCampaing]={SI}>}Campaing)

it enable you to select a specific *PERMANENT* CMPType value.

Best Regards

Re: Set analysis and wildmatch error

antupe — Tue, 14 Jun 2022 10:43:10 GMT

This is working perfectly, thank you very much!!