Dynamic Dashboard Filter Help

[kai_walker-1663]

Hi all,

I am trying to figure out how to create some sort of dynamic filter for a dashboard I am creating. The idea is for the user to filter by either the Client name OR the Site name, but not both.

I’m unsure how possible this is but the closest I have got is this -

  filter: client_or_site {
    type: string
    sql: {% condition %} ${retailer_name} {% endcondition %} OR {% condition %} ${site_display_name} {% endcondition %} ;;
  }

However, as well as this works I wanted to know if there is a way to tick either Client OR Site and then use another filter to then pick the Clients OR the Sites. Anything similar to this would be perfect as well, I mainly just want a method where they don’t have to manually enter names which is what it currently is like using the above LookML.

I hope this makes sense and I’m happy to answer any further questions. Thanks in advanced for any help given!