Action in the mashup

[male_carrasco]

Hi all,

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?

[Chanty4u]

You can create on open trigger 

For report period you can use below search string 

=aggr(max(Date), YearMonthField)

[male_carrasco]

Thanks, @Chanty4u  do you mean in the mashup?
In the sense application, the trigger work properly, but in the mashup doesn't work.