Activity_Lag and Remap_Timestamps

Hi Everyone!

Can you please help me?

I am trying to build a KPI related to the time spent on average to perform an activity. Additionally, I have to only count the working hours (and for that, I already have a variable created named "Working Hours")

To do so, i am using this formula:

CASE WHEN ACTIVITY_LAG (....) = 'ABC'

THEN

HOURS_BETWEEN(... ,

ACTIVITY_LAG ( ...... ))

This formula is working, but the problem is that I need to calculate only the working hours.

How can I do it? I am trying to "remap_timestamps" but it is not working..

Thanks in advance

Page 1 / 1

Hi @filipe.coral ,

For us, on premise, the data model contains a setting regarding work hours (calendar). This allows us to define working days and hours, which should be taken into account when calculating throughput times.

Not sure if this settings exists in the cloud and if so where.

Hi @joos.buijs .

Thanks for your answer. After some tries, I could solve the problem by doing a subtraction of timestamps using a variable more or less like what you are saying.

Many thanks,

Filipe

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN