Cascading filters for independent dimensions

Question

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....

abhinavt · Accepted Answer

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-parameter/m-p/22254#M468

" 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 "

DRay · Answer

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

DRay · Answer

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 · Answer

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/18862 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.