Forum Discussion

zohebakber's avatar
zohebakber
Cloud Apps
10-19-2023

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

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 

dashboards & reporting

2 Replies

Replies have been turned off for this discussion
  • olegfil's avatar
    olegfil
    Sisense Employee
    10-23-2023

    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