1 Reply Latest reply on Jan 6, 2017 3:15 PM by Sarah Ebreo

    Create "OR" quick filters on a dashboard

    Steve Zadroga
    Steve Zadroga Jan 5, 2017 6:45 AM

      Is there a way to make a quick filters follow "OR" logic instead of "AND" logic?  For instance,  I have a drop down of car types and I want to have another filter that uses OR logic based on the location it was built.  For example, someone could select "Ford" OR "Detroit".

      • 117 Views
      • Tags:
        • 1. Re: Create "OR" quick filters on a dashboard
          Sarah Ebreo
          Sarah Ebreo Employee Jan 6, 2017 3:15 PM (in response to Steve Zadroga)

          Hi Steve,

           

          This may be possible using parameters and a calculated field.

          1. Right-click Car Type and Location fields and select Create Parameter
          2. Create the following calculated field: [Car Type] = [Car Type Parameter] OR [Location] = [Location Parameter]
          3. Place the calculated field onto Filters and select True > OK.

           

          See the attached workbook as an example. If this does not solve your question, can you provide a sample packaged workbook and a mock up of the desired result?

           

          Best,
          Sarah