I created a mashup that includes KPI objects with a 'Report Period Objectives' filter. This filter allows users to select a month year (e.g. May 2023) and is set to always have one value selected.
To ensure that the maximum value for 'Report Period Objectives' is selected, I included a sheet action that selects the max value for this field.
However, I've encountered an issue with the mashup. When I change the month and new data becomes available for the current month, the mashup doesn't apply the action to select the max value for 'Report Period Objectives'. Strangely, the action works correctly in the application.
I suspect that the 'always one selected value' option for the filter is affecting the action in the mashup.
Has anyone else experienced this issue or knows how to fix it?