cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
At times, you might want to limit the items suggested in a dashboard filter by another field's value (for example: enable the user to choose between all subcategories under a specific Product Category).
This functionality can be achieved using a dependent filter and limiting the parent filter using a background filter
CascadedFilter.png
However, when there is only 1 value allowed for the user, the parent's selection of a single value only might seem odd.
Another way to limit the filter could be by using a single filter and applying an advanced filter over it.

Steps to Creation

1. Add a new dashboard filter over the field that the users should be able to choose from (In our example, Product.ProductSubcategory.
2.  Open the Advanced Filters Tab, and replace its content with the following 
 {
  "attributes": [
    {
      "dim": "[Product.productCategory]",
      "filter": {
      "members": [
        "Bikes"
        ]
      }
    }
  ],
  "custom": true
}
The dim attribute should be set to "[table.column]" (including the brackets), and the members should include a list of all values in the internal filter.
Advanced_Filter.png
3. Set the new advanced filter as a background filter
 FinalFilter.png
Version history
Last update:
‎03-02-2023 08:28 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: