Hi all,
I would like to build a chart which shows the number of open activities at a given day.
In our data activities are a combination of a task (e.g. modelling or testing), and a (lifecycle) status (e.g. new, in progress, done, rejected). I would like to plot per day the number of open tasks/activities of a certain type.
I currently have the activity timestamp aggregated to day as DIMENSION, and the following KPI:
MOVING_COUNT_DISTINCT(
CASE WHEN
MATCH_ACTIVITIES(NODE[Testing - In progress] , EXCLUDING[Testing - Done, Testing - Rejected] ) = 1
THEN L33_V_MBD_INZICHTEN_STATUS.FEATUREAPGID
ELSE NULL
END
,-999,0)
In (my?) theory this should use the activities up until the day, and then determine whether the case contains an open testing task or not. However, my current result is incorrect:
image1223594 18.2 KB
Which trick am I missing?
BTW: were on CPM4.6
Happy holidays!
