Hello AWS Community,
I am using Docebo LMS which has integrated with Quick Sight. As I am getting onboarded, I have encountered an issue with the expected behavior of dependent dropdown filters. I would like to understand if anyone else has experienced this issue or found a workaround to improve the filtering functionality.
We are using multiple control filters in a dashboard to enhance data segmentation. Specifically, we have created three custom filter lists:
Business Unit (BU)– user additional field1
BU Leader – user additional field2
Direct Manager - user additional field3
The expectation is that selecting a BU should dynamically filter the BU Leader field to display only relevant values corresponding to the selected BU. However, the behavior of the filters does not align with this expectation.
Expected Behavior:- When in VIEW mode, as soon as a user selects a BU, the values in the BU Leader dropdown should immediately update to show only those relevant to the selected BU.
Current Behavior:
- When a BU is selected, the BU Leader dropdown does not update dynamically to reflect only the relevant options.
- If a user manually selects a value in the BU Leader field (even if unrelated to the selected BU), only then does the dropdown update and show the correct corresponding values.
- This means users must already know a corresponding BU Leader to select, which negates the utility of a dependent dropdown.
Additional Observations:
After testing, the filtering only works correctly if the following steps are taken:
- Unselect all filter values.
- Select the required BU checkbox and apply the filter.
- The BU Leader field remains unchanged.
- Select any one checkbox in the BU Leader field and apply the filter.
- The BU Leader field now correctly updates with the relevant values.
- This process must be repeated for each dependent filter.
This additional complexity undermines the usability of the ‘Show relevant values only’ option. Has anyone in the community experienced similar issues with dependent dropdown filters in Docebo’s Advanced Insights? If so, how were you able to resolve or work around this limitation? Any insights or suggestions would be greatly appreciated.
Regards,
Binu