Hi, I want to calculate the throughput time between a certain activity and "now"; ideally speaking I'd like to do a query like this one that is forbidden:
CALC_THROUGHPUT(FIRST_OCCURRENCEE'activity name'] TO TODAY(), REMAP_TIMESTAMPS("ACTIVITIES"."ACTIVITY_START", DAYS))
How can I resolve this?
Thanks a lot