I have a sales dataset with a lot of dataset parameters on the “where clause” (ex: category1, category2, category3, brand, sku). I then have a sku dataset to list the unique values for the analysis parameters controls.
I need the parameters controls to be interdepending between each other but not as a cascade filter because I don’t want the user to have only one order of filtering (category 1 >> category 2 >> category 3 >> brand >> sku)
The user must be able to start filtering by category 3 or sku if he wants, but the other controls must show only relevant values as well when one control is defined. Is there a way to do that?
I tried to use parameters on the sku dataset as well, so that it would filter the dataset and filter the values shown, but it doesn’t work
Select every parameter (and repeat process for each parameter on sheet). They should respond to each other the way you’d like.
*Note, the behavior may be odd sometimes as once you’ve set your first filter, to reset your search or start again through a different filter, you’ll first need to reset any others to ‘All’ option.
Let me know if you have any additional questions or if this helps for your case!
I’ve tried to do that already but when I aplied the ‘show relevant values only’ the filters don’t show all the unique values for selection, they only show the default value:
Hi @vanessabp,
Interesting, this may be a some of the odd behavior I mentioned. To test this I created 3 filters; region, country and city. While all are set to ‘All’. I set the city and country shows only relevant value
Same thing if I check Region instead, it only shows relevant option
Then, if I switch City, relevant options for country change to match new city.
While testing, I did run in to an issue where once selecting a new City, I had to then reset the Country filter before it produced the relevant values on the drop down. So something like that may be happening for you.
Are you able to share your this analysis to Arena view so that I could test out to see where the error may be occuring?
As I was building the report on Arena I changed everything to english so it would be easier and then it worked! haha
But I would like to know if that’s an expected behaviour or if it is a bug >> when I use the static default value as “All” for the parameters everything worked as expected, but when I use a portuguese word “TUDO” it doesn’t show the unique values for the fields.
I created 2 parameters for the same fields, mapping the values from the same dataset field, but with the different static values, the ones with “all” works, but the ones with “TUDO” doesn’t, check it out:
One other thing you could do though, if built in English, you or the user can switch the overall language of the dashboard to Portuguese and the filters will show ‘Tudo’ the way you intend.
That could be a work around for this instance?
