I am looking to set up a chart widget that can be dynamically filtered based on values from other fields on the same dashboard. Specifically, I want the chart, which is connected to the Case object, to update its data when a user selects a value from a dropdown field (for example, an Account field related to the Case). This would allow users to filter the chart data according to the field they select, providing a more tailored and interactive experience.
Any guidance on how to achieve this dynamic filtering within the dashboard would be greatly appreciated!
Instead of adding a lookup, use a quickfilter component. I believe as long as you're on 8.1.4 or higher you can have that filter a chart elements directly.