topic Re: IGNORE Filter on expression KPI in App Development

IGNORE Filter on expression KPI

FelipeK16 — Thu, 17 Nov 2022 14:26:54 GMT

Hello friends,

I am struggling with this Issue

I have a filter pane with a field named period term that includes 2 segments, 1-Month and 12-Month

And

I have a KPI which its expression is

Count(distinct {<[GSDP.termstartdate_vp.autoCalendar.Year],
[GSDP.termstartdate_vp.autoCalendar.Month],CRM.I_CMPGN={'9098'}>}VIN_)

The VIN_ is the Iduser

This expression is making a count distinct of this ID users that have received an E-mail (9098)

I want that when selecting any segment from the filter pane it doesn't affects this KPI

I have tried by including the 1 regular expression but didn't work,

also I have tried adding $:: to pick only the I_CMPGN

I thank any help

Regards,

Re: IGNORE Filter on expression KPI

QFabian — Thu, 17 Nov 2022 20:23:13 GMT

Hi @FelipeK16 ,if i understood well, you just have to add the field/filter inside the set analysis to avoid its filtering

Count(distinct {<[GSDP.termstartdate_vp.autoCalendar.Year],
[GSDP.termstartdate_vp.autoCalendar.Month],CRM.I_CMPGN={'9098'} ,FieldToIgnore = >}VIN_)

Re: IGNORE Filter on expression KPI

FelipeK16 — Thu, 17 Nov 2022 20:28:51 GMT

Hey Fabian thanks a lot for your reply, you understood well, I don't know why when adding the field as you suggest, when using the filter which is the same field, it is still afecting the KPI,

This is the measure as you suggested

Count(distinct {1<[GSDP.termstartdate_vp.autoCalendar.Year],
[GSDP.termstartdate_vp.autoCalendar.Month],CRM.I_CMPGN={'9098'},CRM.periodterm>}VIN_)

And I have this condition on the filter

=if(Match(CRM.periodterm,'1-Month','12-Month'),CRM.periodterm)

I have implemented this condition because I want the filter only to show those period terms

1 Month and 12 Month,

Do you think the condition If can be the Issue that is not letting the expression to ignore the field periodterm?

Re: IGNORE Filter on expression KPI

QFabian — Thu, 17 Nov 2022 20:32:40 GMT

Probably, maybe you can create another periodo field with just the desired values and use that new field instead

Re: IGNORE Filter on expression KPI

FelipeK16 — Thu, 17 Nov 2022 21:27:20 GMT

Yes, the If condition was the issue

Instead of this I have used

=aggr(Only({<CRM.periodterm = {'1-Month','12-Month'}>}
[CRM.periodterm])
,CRM.periodterm)

And now the suggested expression is ignoring the filter

Count(distinct {<[GSDP.termstartdate_vp.autoCalendar.Year],
[GSDP.termstartdate_vp.autoCalendar.Month],CRM.I_CMPGN={'9098'} ,FieldToIgnore = >}VIN_)