Cascading filters for independent dimensions

[abhinavt]

Hello Team,

We have a use case for dependent filters where we want to control(lock/unlock) each filter unlike existing dependent filters functionality where filters are grouped.

We're using a live connection. For eg, If we have Product, Geography & Time. I want to all products under "Product" filter dropdown that are only relevant to "US" when "US" is selected as Geography filter.

Right now this can be only achieved using dependent filters , where we cant enable/disable each filter within a widget.

TIA

[DRay]

Hello @abhinavt,

Thank you for your question.

I was able to find this post that may help, https://community.sisense.com/t5/build-analytics/hide-dashboard-filter-based-on-filter-title/m-p/188...

You can also use drill-downs to achieve a similar result. Allow users to drill down into sub-reports that contain only the relevant data.

I hope that helps. Please keep me posted.

[abhinavt]

Hello David,

We're discussing similar problem in another thread (https://community.sisense.com/t5/help-and-how-to/pass-dashboard-filter-value-to-data-model-as-a-para...) and we've connected with Sisense Tech Lead and waiting for them to get back to us.

Thanks,

Abhinav T

[DRay]

Hello @abhinavt ,

I wanted to follow up to see if the solution I offered worked for you.

If so, please click the 'Accept as Solution' button so other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.

[DRay]

Hi @abhinavt.

Were you able to get this resolved? If so, can you provide the solution here so others can find it?

Thank you.

[abhinavt · Accepted solution]

Posting the solution from another thread/discussion :

https://community.sisense.com/t5/help-and-how-to/pass-dashboard-filter-value-to-data-model-as-a-para...

 " We found a working solution for this, we were advised to convert all our dashboard filters to background filters. Later we made some changes to the code while embedding such that only the relevant selections from our embed platform are passed to each dashboard filter.

Note :This cannot be done through the frontend dashboard unless we add dependent filters. However, it's great that we found a solution through embedding "