Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago

Filters on all pages

Hi, 

I have applied several filters to my dashboard on all pages, but not sure it quite does what I need I to. 

 

I have a drop down filter and it displays values that it shouldn't. It's almost as if the filters applied on all pages uses an "or" opposed to an "and".

 

If all filters applied used an "and" then I would see the correct values within my filter drop down but I don't. Any idea how to get around this please?

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    M_SBS_6 , not very clear. If the filter pane is used Or is within a field, across field it is and

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • M_SBS_6's avatar
      M_SBS_6
      Icon for Helper V rankHelper V
      3 years ago

      My filter on all pages are 

      Year > 2015

      Status = Live

      Type = New

       

      My filter which is "Company" shows me BRNT_Canada but not sure why as it doesn't match the filtered criteria above. 

      Year > 2015

      Status = Live

      Type = Rec (this is a different value to the filters)

       

      So to me, the criteria used on filter all pages is 

       

      Year > 2015

      OR

      Status = Live

      OR

      Type = New

       

      Where as I want to only show "Company" that meets all 3 criteria 

       

      Year > 2015

      AND

      Status = Live

      AND

      Type = New

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    HI  M_SBS_6 

     

    maybe this could be the reason.

     

    Do you use a model with multiple tables and relations? IIf yes please be aware that filters go only through the relations as allowed by the direction (see arrow in data model)

     

    so in my example above

    - Dim Date filters Base Sample

    - Dim Type filters Base Sample

    - Dim Type DOES NOT fitler Dime Date

    - DimDate DOES NOT filter DIM Type

    - Base Sample DOES NOT filter Dim_Type or Dim_Date

     

    You can change the filter direction behaviour by double-clicking on the relation but please be aware that it could end in not following best practices

     

    If this this does not help then we need more information (data model and screen shot)

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

    -----------------------------------------------------

    LinkedIn