Now i want to have this number for Change Price as a single KPI number, my idea was to use the count table for the kpi and a Component filter with 'FILTER PROCESS EQUALS 'Change Price''. But it shows me a much larger number. Can pls anyone help me. Thanks in advance, king regards Louis
Page 1 / 1
I think that for the component filter, you need to filter directly on the activity name.
KPI: COUNT_TABLE("_CEL_MERGED_ACTIVITIES")
Component filter:
FILTER "_CEL_MERGED_ACTIVITIES"."ACTIVITY" = 'Change Price';
Thanks a lot, now it works
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.