Skip to main content
Solved

Hi all, i have an olap table with the dimension of all my activities and as my kpi the count of the activities (done with count table of all activities).

  • June 3, 2024
  • 2 replies
  • 14 views
L
Level 6

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 Louisin the olap table

Best answer by rita.kiss12

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';

    2 replies

    rita.kiss12
    Level 7
    Forum|alt.badge.img+3
    • rita.kiss12
    • Level 7
    • Answer
    • June 6, 2024

    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';

    L
    Level 6

    Thanks a lot, now it works

    Community Code of ConductAccessibility statement