Skip to main content
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?

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

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

It works perfectly, thank you Sverre!

Reply


Terms & ConditionsCookie settings