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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.