3 Replies Latest reply on Jun 29, 2018 3:26 PM by Gerardo Varela

    How to edit a filter to not show a particular value?

    Anjali Sn

      Hi,

       

      I have a filter that looks like follows:

       

      Screen Shot 2018-06-29 at 10.23.41 AM.png

       

      Is it possible to edit the above filter such that it does not show the "Unknown" value but when "All" is selected, it includes the data from the "Unknown" value as well? How to do it?? Many thanks!!

        • 1. Re: How to edit a filter to not show a particular value?
          Michael Hesser

          Hi Anjali;

           

          Here's one option:

          Create a SET of your Dimension

          Exclude the values you never want to use

          Drop the SET into the filters ABOVE your Dimension

           

           

          --> Ooops: looking more closely I see this does not fulfill your last requirement (use "Unknown" in total)... I'll keep looking

          • 2. Re: How to edit a filter to not show a particular value?
            Ken Flerlage

            Perhaps you could create a parameter with the list of values 1-5 plus "All". You could then create a calculated field which does something like this:

             

            IF [Parameter]=[Value] THEN

                // This will be one of our 1-5 options, so we want to include it.

                "Include"

            ELSEIF [Parameter]="All" THEN

                // If All, we just want to include everything.

                "Include"

            ELSE

                // For all other options, exclude the value.

                "Exclude"

            END

             

            Then create a filter from this calculated field and only select the "Include" value. This should work as you requested, with one primary limitation. Parameter lists only allow one selection at a time, so you won't be able to select multiple values. For instance, you won't be able to show 1 and 2, but not 3, 4, and 5. You'll be able to select one value or all.

             

            Hope this helps. If so, please be sure to mark this answer as helpful or, if it solves your problem, mark it as the "correct answer." This will help others with similar problems in the future. Thanks!

            • 3. Re: How to edit a filter to not show a particular value?
              Gerardo Varela

              The closest I've seen this done is in the following thread.   It's almost what you are asking for but not quite there.  Hopefully, it gives you some ideas.

               

              Select a value permanently and hide it in quick filters

               

              Regards,

              Gerardo