COUNT unique users in one process

Hello, Collegues!

I am trying to clculate unique users per one process. I was trying to solve it by function SOURCE/TARGET. I didnt get well result. Is there any solutions to solve it?

Hi!

Could you please describe what you want to achieve and what you have done so far in more detail?

Best,
Viana

Hi, thanks for reply.

I need to count unique users per process. I need to achieve one unique user who was involed in one process.

COUNT(DISTINCT CASE WHEN PU_FIRST(“CASES”, “EVENTS”.“USER”)=PU_LAST(“CASES”, “EVENTS”.“USER”) THEN ‘1’ ELSE NULL END)

If @v.kalversberg you have any suggestions, please let me know.

Thanks.