thanks for your answers. The solution with the column chart helped me a little bit, but it didn’t solve my problem.
When I use this column chart and filter on a specific month I see all goods issue in this month. I also can export all cases which have a goods issue in this month.
But the problem is that I have another KPI which should adapt if i apply the filter. This doesn’t work.
So my column chart:
Dimension - ROUND_MONTH("_CEL_O2C_ACTIVITIES".“EVENTTIME”)
KPI - COUNT("_CEL_O2C_ACTIVITIES".“ACTIVITY_EN”)
Component Filter - FILTER “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” = ‘Record Goods Issue’
My single KPI (shows me how many of the sales order items had a change of the goods issue date
(SUM(PU_COUNT_DISTINCT(“VBAP”, “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN”, “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” = ‘Goods Issue Date Changed’)*1.0))
So I want to see all Goods Issue of one month and see then how many of the considered cases had a change of the goods issue date.When I apply there the same component filter,it works.
I don’t like to work with a component filter here, because then I’m very inflexible. Is there another possibility to get those numbers or is it the only way?
So the ideal way for me would be
KPI: # of Goods Issue Date changes (based on all SOItems)
Then setting a filter for one month -> KPI adapts to KPI: # of Goods Issue Date changes (based on all SOItems with a goods issue in the filtered month)