I have a bar chart with a pulldown menu, which allows the user to select which data to chart. I use datasource() to populate the series with data whenever the pulldown menu is changed.
I have six options in the pulldown menu. All of my users have data for the first five options, but the sixth piece of data is optional for the users. To date, about 25% of my users actually have data to display for this sixth option. In the use case where the user does not have data for the sixth option, I need to clear the chart when that option is selected from the pulldown. Currently, the chart will continue to show whatever the last selection on the pulldown menu was, and it's confusing to see data when I expect no data.
Is there a way to force the chart to clear its data?
Here is a link to video to show how the chart works: https://nimb.ws/d93Xel
--Trudy Voorhees