Hi Folks

I have a Knowledge Model with some KPIs and a View displaying it. I want to allow the user to see the value of the KPIs for different periods. To achieve this I´m trying to create a Filter and a Variable.

The Filter helps me to filter for some specific conditions to calculate my KPI (see filter statement below)

FILTER TO_STRING(ROUND_MONTH(PU_FIRST("JIRA_ISSUES", "_CEL_JIRA_ACTIVITIES"."EVENTTIME", "_CEL_JIRA_ACTIVITIES"."ACTIVITY_DE" = 'Fehlende Ware')), FORMAT('%Y-%m')) = ${monitor_timefilter}

The Variable ${monitor_timefiler} is the one that I want to update based on user selection (month of their interest) - > the KPIs should be updated based on user selection.

So far I can do this but I need to update the Variable ${monitor_timefilter} manually. Any hints on how to achieve this would be highly appreciated.

Thanks in advance