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