group time into hours

[#1]

Hi, I have a variable that displays 'YYYYMMDD hh:mm', but I only need the hours so that I can display it in a chart axis. I've tried 'time(Timestamp#(fieldname,'YYYYMMDD hh:mm'),'hh:00') as newVarName' but I got

How can I group them into only 1 of each hour? Thanks.

[tresesco]

Try with hour(), like:

hour(Timestamp#(fieldname,'YYYYMMDD hh:mm')) as newVarName

[ashfaq_haseeb]

Hi

Try

hour(fieldname) as Hour

Regards

ASHFAQ

[er_mohit]

Try this

Interval(Timestamp#(fieldname,'YYYYMMDD hh:mm'),'hh')  as Hour

[alok0017]

Try to apply:

=Hour(Timestamp(colomn name,'hh'))

[Wahl154169]

try this hour(fieldname) as Hour

regards

navyarmyccu