I have a dashboard with a serial chart controlled by a category selector. I set the selector to default to the first category.
But when the dashboard is first opened, the selector seemingly is inoperative. Instead, the chart reflects the sum of values for ALL categories. That yields very incorrect data (in this case, twice the correct amount.)
If I use the selector to select another category and then go back to the default category, the selector properly filters the data displayed in the chart.
Is there a solution to make a selector filter the data as soon as the dashboard opens?