Forum Discussion

ramansingh89's avatar
ramansingh89
ETL
04-02-2025
Solved

Single Filter against multiple columns

Hello Experts

I wonder if there is way to build a single filter on Dashboard that interacts with 2 different columns in the database? Here is an example

2 columns in table:-

- primary City
- secondary city

On the dashboard level, we would like to build a single filter called 'city' which should filter against both of these columns using OR condition (eg: select sum(sales) from customer_orders where primary_city='Toronto' or secondary_city='Toronto'

Blox
  • TriAnthony's avatar
    TriAnthony
    04-03-2025

    Hi ramansingh89,

    You can add each column as a dashboard filter, and then use the Filter Relationship feature to create the OR logic. To cascade the selection from one filter to the other and ensure the two filters are always synchronized, you can use the script in the Dashboard Script for Automatic Filter Cascading article. To declutter the UI and avoid confusion for the users, you can use the free and officially supported Hide Filters add-on by Paldi Solutions to hide the second filter.

    This way, users will only see and interact with one filter, but it will automatically pass the selection to the hidden second filter as well in the backend.

    Let me know if you have any follow-up questions.

    -Tri

5 Replies

  • michael_qbeeq's avatar
    michael_qbeeq
    Cloud Apps
    04-03-2025

    Hi Raman,

    You can do that by adding both columns as filters and then clicking on Filter Relationship in filters menu:

    Then in new window create an OR logic between filters

     

    and that should add an additional indicator at the top of the filters. Hope this helps. If you would need any additional assistance feel free to reach out!

    Michael Becker

    qbeeq.io 

  • Jake_Raz's avatar
    Jake_Raz
    ETL
    04-03-2025

    Hmm, I'm not sure of a way to do this out of the box. This might be something you could do with the BloX plugin, but I don't know enough about BloX to say for sure. If you have Blox, though, I'd explore that avenue first, if you can.

    If not, and if michael_qbeeq's suggestion isn't viable for you -- say, for example, you're like me and using an older version of Sisense that doesn't have that feature -- then you may just have to go with listing both fields in the dashboard filter and instructing users to only activate one or the other. Not ideal, I know.

    It might be possible to use a dashboard script to grab the value entered in one of the fields and then populate it into the other, then (with the same script or an additional one) use OR logic, rather than AND logic, for the two filters. That way, even though both filters will be listed, users only have to key in one of them. However, I don't know of a script off-hand that can do that. Maybe try searching the forums to see if you can find a somewhat-similar script (a dashboard script that's modifying the dashboard-level filters somehow) then seeing if you can use an AI chatbot to refine it down to something that'll work for your specific purposes. I've used this particular Sisense-specific chatbot in the past with some success, though like most LLM-based chatbots, it can sometimes get stuff pretty wrong. Here's an example of a dashboard script that might work as a starting point, I've used it to auto-set certain filter values at the dashboard level.

    Sorry I don't have more specific or helpful advice. Good luck! If you figure out a decent script to do this, let me know, as I'd also be interested in accomplishing something like this!

  • TriAnthony's avatar
    TriAnthony
    Admin
    04-03-2025

    Hi ramansingh89,

    You can add each column as a dashboard filter, and then use the Filter Relationship feature to create the OR logic. To cascade the selection from one filter to the other and ensure the two filters are always synchronized, you can use the script in the Dashboard Script for Automatic Filter Cascading article. To declutter the UI and avoid confusion for the users, you can use the free and officially supported Hide Filters add-on by Paldi Solutions to hide the second filter.

    This way, users will only see and interact with one filter, but it will automatically pass the selection to the hidden second filter as well in the backend.

    Let me know if you have any follow-up questions.

    -Tri

  • Angelica121's avatar
    Angelica121
    Data Storage
    04-04-2025

    I am trying to filter multiple columns in a dataset using a single filter, but it doesn't seem to be working as expected. The filter doesn’t apply correctly across all selected columns, and I can’t get the results I need. How can I fix this?

    This issue is especially critical for applications like PoliceClearanceOnline where accurate filtering is essential to process and retrieve the necessary data for clients effectively.