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

[zohebakber]

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 

[zohebakber]

Any suggestions here?

[olegfil]

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