I want to add a component filter to my chart in studio analysis that Filters it to only show values between 08:00 and 16:30. How do I do this?
+6Best answer by Sverre Klein
hI @koert.kritz11,
FILTER HOURS("ACTIVITIES_TABLE_PO"."EVENT_TIME") BETWEEN 8 AND 16.5;
This basically states we only want time between 08:00 and 16:30. I'm not sure whether 16.5 has the desired behavior, so please let me know if you find abnormalities.
Kind regards,
Sverre Klein
+14hI @koert.kritz11,
FILTER HOURS("ACTIVITIES_TABLE_PO"."EVENT_TIME") BETWEEN 8 AND 16.5;
This basically states we only want time between 08:00 and 16:30. I'm not sure whether 16.5 has the desired behavior, so please let me know if you find abnormalities.
Kind regards,
Sverre Klein
+6hI @koert.kritz11,
FILTER HOURS("ACTIVITIES_TABLE_PO"."EVENT_TIME") BETWEEN 8 AND 16.5;
This basically states we only want time between 08:00 and 16:30. I'm not sure whether 16.5 has the desired behavior, so please let me know if you find abnormalities.
Kind regards,
Sverre Klein
It works perfectly, thank you Sverre!
Login to the community
No account yet? Create an account
Login with SSO
Celonaut Login Celonis ID LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.