In my dataset I am using an ID parameter. I have multiple parameter controls in my analysis linked to fields from my dataset. When the dataset ID parameter is changed from the default value to another value, the parameter controls in my analysis do not update. They still show the values that are linked to the default dataset ID parameter, not the values that are linked to the new dataset ID parameter. Is there a fix for this that doesn’t involve bringing in a new dataset?
The only fix I know of would be to bring in a new dataset with all of the dataset IDs and the relevant fields in my parameter controls, but that dataset would consist of over 150,000 rows so isn’t currently viable due to performance issues.
on second thought, I think I understand your issue.
You are using a DATASET Parameter in a Custom SQL with a default value. Since this is a direct query with a select default value for the ID, the resulting dataset used in the Analysis will only have the selected ID value of the Dataset parameter.
If you do not want to use another data with all unique values that can be entered for the dataset parameter, another option would be enter them manually (copy and paste all unique value for the Parameter) in the Control Options under Format Control:
I have a DATASET parameter in my dataset, that is mapped to a control in my analysis. The mapped control in my analysis is a dropdown, with values that I have defined myself.
I then have multiple other ANALYSIS parameters that are linked to fields in my dataset. When the control mapped to my DATASET parameter is changed to a different ID, the ANALYSIS parameters do not update to show the data linked to the new DATASET parameter ID. Instead, the ANALYSIS parameters still show the data values linked to the default DATASET parameter value.
I can’t include screenshots as it contains confidential information, but hopefully I’ve explained my problem a bit better.
Hello @Liam, based on the information you have given, I don’t think QuickSight has a way to make that connection to update the default parameter values automatically. It seems like the best way to make something like this work, would be through implementing RLS. If that dataset ID parameter value is being set based on the user that is logged in, and that dataset ID only links to rows that contain certain values that would be returned in the controls, RLS would ensure the proper values are displayed. Then, you would probably want to remove static default values from the parameters that will be expected to change based on the dataset ID parameter value.
Alternatively, you could try to create a control that would display that single dataset ID value, and then based on the value passed in use cascading filters (the Show relevant values button) on the remaining controls based on what is being passed in.
I will mark this as a solution for now, but if you have any follow-up questions please let me know!
Hi Dylan, As we’re integrating the dashboard with our product, The entire point of having dataset parameters is to reduce the dashboard load time. If we come up with RLS, does this help in achieving our main goal? And the request Liam has made is valid. Why don’t we consider it as a bug or Change Request and build the same in the upcoming releases? Please consider this as a major bug.
