1 Reply Latest reply: May 10, 2014 4:57 AM by Toni Kautto RSS

    how to change Time Format

    navneet kaushal

      In an Analysis Bar chart i have created total working hours of an Employee in time format hh:mm:ss , now its coming on the chart but on y-axis the time stamp starts with 12:00:00 am, 3:00:00 am, 6:00:00 am,12:00:00 pm now i dont want it like this i want my y-axis to show

      00:00:00 , 3:00:00,6:00:00,12:00:00,15:00:00,24:00:00. no am pm how can i do it

        • Re: how to change Time Format
          Toni Kautto

          My recommendation is that you set the format in your script so that it is predefined, and then you simply use the formatted field as your dimension.

           

          If you want to have several formats, you can add a new field.

           

          LOAD

            *,

            Time(Time, 'hh:mm:ss') AS TimeWithOutTT

          Inline [

          Time

          12:00:00 am

          3:00:00 am

          6:00:00 am

          12:00:00 pm

          ];

           

          If you want to change the entire format in the application simply change the format variable and then reformat the incoming data.

           

          SET TimeFormat='hh:mm:ss';

           

          LOAD

            Time(Time#(Time, 'hh:mm:ss TT')) AS Time

          Inline [

          Time

          12:00:00 am

          3:00:00 am

          6:00:00 am

          12:00:00 pm

          ];