Skip to main content

imageHere is the code: ROUND_HOUR( "ITT_PRODUCTIVITY_F_SEP_UAT"."EVENTTIME" )

Hi @koert.kritz11,

 

There is an easy & alternative but, let's say, more ugly way that has worked for me in the past.

 

Instead of using ROUND_HOUR, use HOURS, this returns the integer value of the hour. For instance, 14:00 becomes 14.

 

It returns the dropdown like this and acts as a time filter appropriately.

image 

Let me know if this is sufficient for you 😄

 

Kind regards,

Sverre Klein


Hi @koert.kritz11,

 

There is an easy & alternative but, let's say, more ugly way that has worked for me in the past.

 

Instead of using ROUND_HOUR, use HOURS, this returns the integer value of the hour. For instance, 14:00 becomes 14.

 

It returns the dropdown like this and acts as a time filter appropriately.

image 

Let me know if this is sufficient for you 😄

 

Kind regards,

Sverre Klein

Thank you @sverre.klein11 , it works perfectly!


in combination with a concat you can make its look even better readable:

 

HOURS( "ITT_PRODUCTIVITY_F_SEP_UAT"."EVENTTIME" ) || ':00'

This way you will get your values like 14:00

 

BR

Dennis


Reply