This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Adding additional filter to row filter condition expression

Posted on 09-05-2021 08:13 PM
teamMedina
New Member
Reply posted on --/--/---- --:-- AM

I have a slice with this expression below under row filter condition, I need to add 2 filters but donโ€™t know how to. The filters will be [Milestone]<>โ€œ15 Milestone Logโ€ and [Milestone]<>โ€œ00 Prequalโ€
Please help :-).

AND(
IF(ISBLANK(ANY(Conditions Filter View[Status])), TRUE,[Status]=ANY(Conditions Filter View[Status])),

IF(ISBLANK(ANY(Conditions Filter View[Active Customer])), TRUE, [Customer]=ANY(Conditions Filter View[Active Customer])),

IF(ISBLANK(ANY(Conditions Filter View[Owner])), TRUE, [Owner]=ANY(Conditions Filter View[Owner])),

IF(ISBLANK(ANY(Conditions Filter View[Coordinating])), TRUE, [Coordinating]=ANY(Conditions Filter View[Coordinating])),

IF(ISBLANK(ANY(Conditions Filter View[3rd Party])), TRUE, [3rd Party]=ANY(Conditions Filter View[3rd Party])),

IF(ISBLANK(ANY(Conditions Filter View[Priority])), TRUE, [Priority]=ANY(Conditions Filter View[Priority])),

IF(ISBLANK(ANY(Conditions Filter View[Section])), TRUE, [Section]=ANY(Conditions Filter View[Section]))
)

0 4 164
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

It really depends on how you wish the conditions to work in filters. But for a simple AND() level it could be as below, presuming [Milestone] column is NOT from โ€œConditions Filter Viewโ€ .

AND(
**[Milestone]<>โ€œ15 Milestone Logโ€ ,

[Milestone]<>โ€œ00 Prequalโ€,

IF(ISBLANK(ANY(Conditions Filter View[Status])), TRUE,[Status]=ANY(Conditions Filter View[Status])),

IF(ISBLANK(ANY(Conditions Filter View[Active Customer])), TRUE, [Customer]=ANY(Conditions Filter View[Active Customer])),

IF(ISBLANK(ANY(Conditions Filter View[Owner])), TRUE, [Owner]=ANY(Conditions Filter View[Owner])),

IF(ISBLANK(ANY(Conditions Filter View[Coordinating])), TRUE, [Coordinating]=ANY(Conditions Filter View[Coordinating])),

IF(ISBLANK(ANY(Conditions Filter View[3rd Party])), TRUE, [3rd Party]=ANY(Conditions Filter View[3rd Party])),

IF(ISBLANK(ANY(Conditions Filter View[Priority])), TRUE, [Priority]=ANY(Conditions Filter View[Priority])),

IF(ISBLANK(ANY(Conditions Filter View[Section])), TRUE, [Section]=ANY(Conditions Filter View[Section]))
)

Posted on --/--/---- --:-- AM
teamMedina
New Member
In response to Suvrutt_Gurjar
Reply posted on --/--/---- --:-- AM

Thanks bud, yes, it took care of it Thanks for taking the time

Cheers

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
In response to teamMedina
Reply posted on --/--/---- --:-- AM

You are welcome. However, you may note a general guideline for better app sync performance that equality operators are preferred over inequality operators. So if there are just three or four options for [MileStone] , then it could be better to include in expression something like

OR( [Milestone] =โ€œ30 Milestone Logโ€, [Milestone] =โ€œ45 Milestone Logโ€) , assuming these are other possible values of [MileStone]

Again the sync performance is a somewhat complex topic because it is a combination of many factors.
Hope the below post helps

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Your expression reformatted for my clarity:

AND(
  IF(
    ISBLANK(ANY(Conditions Filter View[Status])),
    TRUE,
    [Status]=ANY(Conditions Filter View[Status])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Active Customer])),
    TRUE,
    [Customer]=ANY(Conditions Filter View[Active Customer])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Owner])),
    TRUE,
    [Owner]=ANY(Conditions Filter View[Owner])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Coordinating])),
    TRUE,
    [Coordinating]=ANY(Conditions Filter View[Coordinating])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[3rd Party])),
    TRUE,
    [3rd Party]=ANY(Conditions Filter View[3rd Party])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Priority])),
    TRUE,
    [Priority]=ANY(Conditions Filter View[Priority])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Section])),
    TRUE,
    [Section]=ANY(Conditions Filter View[Section])
  )
)

Replace IF() with OR():

AND(
  OR(
    ISBLANK(ANY(Conditions Filter View[Status])),
    [Status]=ANY(Conditions Filter View[Status])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Active Customer])),
    [Customer]=ANY(Conditions Filter View[Active Customer])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Owner])),
    [Owner]=ANY(Conditions Filter View[Owner])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Coordinating])),
    [Coordinating]=ANY(Conditions Filter View[Coordinating])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[3rd Party])),
    [3rd Party]=ANY(Conditions Filter View[3rd Party])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Priority])),
    [Priority]=ANY(Conditions Filter View[Priority])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Section])),
    [Section]=ANY(Conditions Filter View[Section])
  )
)
Top Labels in this Space