Hi Matt,

Your formula is correct. When I recreate your formula and put the KPI in an OLAP table and add columns from the case table all is working fine for me.

Could you specify how you are aggregating?

Can you try this? Not sure if this helps.

Count(

distinct CASE WHEN

HOURS_BETWEEN(

PU_FIRST(Cases,Eventtime,Activity=Activity ,

PU_FIRST(Cases,Eventtime,Activity=Activity C)

) < 2

THEN _Case_key

ELSE NULL

END

)

Hi All, Thank you for the responses. This worked. I also think I know why It wasn't working for me before.

In my OLAP table when I had a dimension as Case (which forced one row for every case), I would get the correct answer of 1.

But when I added in another dimension it would give me a total of activities.

I used dimension = activitytable.state

But I don't think this performs the same as dimension = PU_FIRST(case table,activity table.state)

Case - State - Activity - Time

Case 1 - PA - Activity A - 1PM

Case 1 - PA - Activity B - 2PM

Case 1 - PA - Activity C - 3PM

Case 1 - PA - Activity D - 4 PM