3 Replies Latest reply: Aug 6, 2014 5:23 AM by Mohit Sharma RSS

    group time into hours

      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

      Untitled8.png

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