I am little confused with the question with respect to all activities or just a particular activity, however will try to answer both.

Let's say its a particular activity, use an olap table take first column as Table.CaseID and for the count use the following

COUNT (CASE WHEN TABLE.ACTIVITY_NAME='particular activity' THEN 1 ELSE 0 END)

In case its all activities use the following

COUNT (TABLE.ACTIVITY_NAME)

I hope I this helps!

Hi,

if I understood your answer correctly, it isn't quite what I was looking for. Let me try to explain it a bit better.

I have filtered my process to only have the 'Investigate' followed by 'Follow Up' activities shown.

Now I want to count how often the 'Follow Up' activity was executed per case. So f.e. in the case of CASEID=5, I would expect to have the row "Count follow up" only contain 3s since 'Follow Up' was executed 3 times.

I thought since we have the filter anyways, I just need to count how many times there is a row with the same CASEID, but I couldn't make it work/construct a working PQL formula.

Maybe this makes it better to understand.

Try INDEX_ACTIVITY_TYPE and get the max per case. Filtered by the activity you want to count. That will give you the number of times that activity happened.