relevant values change?

Question

Hi,
I have a control that uses relevant values from another parameter. A lot of my filters are based on this control.
When i select all the options in the control based on the relevant field it defaults to select all but actually selects all units in the dataset not just the relevant values. This seems to have changed recently as it was previously working....
Example
ID1	ID2
11	aa1
11	bb1
11	cc1
11	dd1
22	aa2
22	aa2
22	aa3
22	aa4

If i select 11 in ID1 I have the options aa1,bb1,cc1,dd1 if I select all 4 options the control shows all and the filter actually shows all 8 ID2's
As i mentioned at the top upto to a couple weeks ago it was possible to unselect all individually select the 4 units and this would only filter for the 4 units.

While I could simply add a filter for ID1 as well this wont work because over time ID2 can migrate to a different ID1

Answer

Hi,
Thanks for your answer.
Your answer is correct, when you select Adelaide in test 1, in test 2 is shows up as Australia. The issue I am having is if test 2 parameter value is set as  multiple values it will still only show up as Australia however when you select Australia it defaults to select all. When I use a filter based on test 2 it doesn't select Australia it selects all countries. This has been a recent change as it was previously possible to deselect select all, select Australia and it would filter correctly. You can see the issue pretty quickly if you set the parameter value in a chart title that it defaults to select all over the actualy value Australia

Answer

Dear Customer,

Warm Greetings.

Thank you for reaching showing up with your query.

I understand the relevant values doesn't seem to show up correctly in recent weeks.

If I understand your scenario correctly:

-->If you select 11 in ID1 it should show up aa1,bb1,cc1,dd1 but instead shows aa1,bb1,cc1,dd1,aa2,aa2.aa3.aa4(all values in id2) Is that correct?

In order to undersand this better I replicated the scenario at my end with the below mentioned steps:

-> I had two controls and test1 and test2.

In test 1 I shown all the cities and in test2 shown the country with relavent values for test1.

So when I select city like Adelaide In test 2 it shows up as "Australia" so which shows it is working correctly.

Therefore in order to assit better I would like you to provide the screenshots/video or explaining the use case in a better way to help you guide. Meanwhile please have a look at the below document to understand the limitations on cascading controls.

[+]https://docs.aws.amazon.com/quicksight/latest/user/parameters-controls.html

Thank you

Answer

Hello Mark,

I am still checking on it checking internally this seems like a bug. But will have it more investigated from my end. It would have been great to connect and check on screenshare but would try to address you in whatever best way i can.

thanks

relevant values change?

Relevant content