Hi Team,
I am experiencing an issue when using Filters with Specific Values set, specifically with the results when “Select All” is checked.
I have set my control options with Drop Down and I have defined specific values.
Selecting the Values applies the correct calculation to my dashboard, however, when I Select All, it seems to be running the calculation across the entire dataset as opposed to all the selected values that where defined.
My expectation is that the select all should only select the values that are defined.
Am I missing something?
Thanks
D
Hi @deliverit ,
Welcome back to the community!!
Where are these values defined ? Is this a parameter control where you are defining default values?
Ideally when you select All, you are allowing the control to select all control options coming under.
Kindly elaborate the use case with an example for clarity.
Thanks,
Prantika
That is correct. I have tried both methods, using parameter control values and custom filter.
When I select all, it should select all the options that are set.
When you say all the option, do you mean values selected through other controls? or the default values defined in the parameter?
Can you create a sample use case in the Arena for review?
Here is the example in action.
I have set specific values:
It works fine at the beginning:
I uncheck a value and the GTV updates as expected:
Then I recheck the value or select all:
The GTV seems to be including all values outside what is selected even though they are not defined in the list.
Strange behaviour.
Sorry I haven’t used Arena yet and will need to export some data.
I understand it now. Since we are using parameter values as input to filter, we see this behavior as filter automatically interprets All as all values.
However to mimic the behaviour that you intend, you can create a calculated field that maps respective values to the parameter values.
For example :
if param value = fieldname then
fieldname
else if param value =all then
if fieldname = defined value 1 or fieldname=defined value2 … then
fieldname
else
null
end
else
null
end
Also in param config, disable select all option and instead add All as a value.
I have not tested this solution, you may need to tweak a bit based on the data and use case.
This also happens when I don’t use parameters and specify the values in the filter.
I think this is an issue with Quicksights, I have removed the select all option.
Here you can see
Once I recheck the store I initially removed, it clears the filter list.
This is incorrect behaviour.
Here is a link to Arena
Client Names
You can see by unchecking and then recheck a client in the defined list it will then display all clients.
You can keep one filter with the required clients and do not add control for it. Add another filter with the required clients and also add this as control.
Have tried to implement the same in this dashboard.
34600 - Filter selected values
2 Likes
Thanks so much Prantika, it works as expected. I didn’t think of adding an control filter.
Appreciate your efforts in helping resolve this complication.
Works in analytic view, however it doesn’t seem to work when I publish the dashboard. hmm 
Ok, so I deleted the filter and then added them back and it now seems to work as expected.
