cancel
Showing results for 
Search instead for 
Did you mean: 

Widget to show exclude categories instead of Include while selecting dashboard filter

zohebakber
9 - Travel Pro
9 - Travel Pro

Hi Team,
I have a requirement where I select a dashboard filter and it filters the categories accordingly.
For example:
I have a retailer filter on the dashboard. When I apply a particular retailer filter, my corresponding brands are displayed in the widget. However, I want to show the brands which are missing. That is, the brands which are excluded for that selected retailer.

If there are total of 4 brands B1, B2, B3, B4

Retailer R1 has two brands - B1 and B2.

When I apply R1 dashboard filter, I want to show B3 and B4 instead of B1 and B2


Any help will be greatly appreciated.

Regards,
@Harry @harikm007 @Oleg 

2 REPLIES 2

zohebakber
9 - Travel Pro
9 - Travel Pro

Any suggestions here?

olegfil
Sisense Team Member
Sisense Team Member

hi @zohebakber , i think you will have to know which to exclude before applying the filter. For that execute a jaql request to fetch brands for the current user and then update the dashboard filter with only the excluded options