2 Replies Latest reply on Oct 1, 2018 9:49 PM by Shinichiro Murakami

    Dynamic Multi Variable Filtering

    Edward Peugh

      Having a challenge.

       

      Given the following Dataset:

       

      Produce          Type      Color           Shape

      Apple              Fruit      Red           Round

      Orange           Fruit      Orange      Round

      Beet                Veg      Red           Round

      Banana           Fruit      Yellow      Not Round

      Cucumber       Veg      Green       Not Round

      Strawberry     Fruit      Red          Not Round

       

      I am trying to allow the user to select and filter across each data field.  Obviously it can be done with quick filters for each individual field, however I am trying to create dropdowns of expected views a user may want to see.

       

      For example show me all records where the following Criteria are met:

       

      1) Shape = Round OR Color = Green

       

      Returns:

       

      Produce          Type      Color           Shape

      Apple              Fruit      Red           Round

      Orange           Fruit      Orange      Round

      Beet                Veg      Red           Round

      Cucumber       Veg      Green       Not Round

       

      2) Type = Fruit OR Shape = Not Round

       

      Returns:

       

      Produce          Type      Color           Shape

      Apple              Fruit      Red           Round

      Orange           Fruit      Orange      Round

      Banana           Fruit      Yellow      Not Round

      Cucumber       Veg      Green       Not Round

      Strawberry     Fruit      Red          Not Round

       

      3) Produce Starts with "B" Or Color = Green

       

      Returns:

       

      Produce          Type      Color           Shape

      Beet                Veg      Red           Round

      Banana           Fruit      Yellow      Not Round

      Cucumber       Veg      Green       Not Round

       

      When using a parameter to control these filters I can successfully select 1 of these datasets.  However what if a user wanted to allow Users to select any one of these filters? See the Data from set 1 and 3.  That would look like this:

       

      Produce          Type      Color           Shape

      Apple              Fruit      Red           Round

      Orange           Fruit      Orange      Round

      Beet                Veg      Red           Round

      Banana           Fruit      Yellow      Not Round

      Cucumber       Veg      Green       Not Round

       

      Any Thoughts?