8 Replies Latest reply: Dec 12, 2017 12:07 AM by Luis Madriz RSS

    Filter a dimension using an If OR statement

    Tony Anthony

      I want to filter a field on a bar chart using an If OR statement in expression editor. The field title is ActivityType, there are six different activities types. I want to filter on three of them.  This is what I enter in the expression editor:

          =if(ActivityType='Call' OR (ActivityType='Mailers' OR ActivityType='Drop-In', ActitityType)

       

      This creates for the tress activity types, and a fourth bar that combines the value for all of the activities types.  The legend shows on the three activity types that I filtered on.  What do I need to do to exclude the fourth bar?