I have start date and end date controls that are parameterized. Additionally, I have two other controls: Type and Status, both of which are also parameterized. I was able to make Type and Status dependent on each other by selecting only relevant values. However, I wasn’t able to achieve the same for the date controls.
For example, if I select a date range from January to August, I expect only the types and statuses available during this period to be shown, but currently, all statuses and types are displayed. Could you please help me figure out how to make all controls dependent on each other, so only relevant values are shown based on the selected dates?
Hi @hellosai321,
With the way that parameters are setup, this is a limitation within Quick Sight. Since each filter is setup to only control one thing each, it does not have the ability to gather relevant values for the rows that would technically fall within your date range. So for instance, the ‘start date’ parameter is just checking dates that are on or after the set date, and then the ‘end date’ parameter is just checking for dates that are on or before the set date.
Hi @hellosai321,
In regards to limiting your control options based on your date field, unfortunately there’s no real work around. I would suggest that the only possible solution would be to add some other parameter control that could assist in limiting those values if one exists.