2 Replies Latest reply: Feb 14, 2018 2:30 AM by Mariya K RSS

    Axis with dates

    Mariya K

      Hello everyone!

      I'm trying to make a chart where X axis represents datetime, Y axis represents name of an object and inside there are stacked bars which are colored by Status.

      For example sections from '01.01.2017 00:00:00' to '01.01.2017 00:20:00' of object A should be colored red and section from '01.2017 00:30:00' to '01.01.2017 00:40:00' of object A should be colored yellow.

      I'm stacked at trying to display dates on X axis. What should I write in measures/dimensions?

       

      I'm using the following sample data:

      load * inline

      [ DateTime, Object, Status

        '01.01.2017 00:00:00', A, status1

        '01.01.2017 00:10:00', A, status1

        '01.01.2017 00:20:00', A, status1

        '01.01.2017 00:30:00', A, status2

        '01.01.2017 00:40:00', A, status2

        '01.01.2017 00:50:00', A, status1

        '01.01.2017 01:00:00', A, status3

        '01.01.2017 01:10:00', A, status1

        '01.01.2017 01:20:00', A, status1

        '01.01.2017 01:30:00', A, status2

        '01.01.2017 01:40:00', A, status3

        '01.01.2017 01:50:00', A, status3

        '01.01.2017 01:00:00', A, status3

       

        '01.01.2017 00:00:00', B, status1

        '01.01.2017 00:10:00', B, status1

        '01.01.2017 00:20:00', B, status2

        '01.01.2017 00:30:00', B, status2

        '01.01.2017 00:40:00', B, status2

        '01.01.2017 00:50:00', B, status2

        '01.01.2017 01:00:00', B, status3

        '01.01.2017 01:10:00', B, status1

        '01.01.2017 01:20:00', B, status1

        '01.01.2017 01:30:00', B, status2

        '01.01.2017 01:40:00', B, status3

        '01.01.2017 01:50:00', B, status1

        '01.01.2017 01:00:00', B, status1

       

        '01.01.2017 00:00:00', C, status1

        '01.01.2017 00:10:00', C, status1

        '01.01.2017 00:20:00', C, status1

        '01.01.2017 00:30:00', C, status1

        '01.01.2017 00:40:00', C, status1

        '01.01.2017 00:50:00', C, status1

        '01.01.2017 01:00:00', C, status3

        '01.01.2017 01:10:00', C, status1

        '01.01.2017 01:20:00', C, status1

        '01.01.2017 01:30:00', C, status2

        '01.01.2017 01:40:00', C, status3

        '01.01.2017 01:50:00', C, status3

        '01.01.2017 01:00:00', C, status3

      ];

      Below is the chart I'm trying to make (x axis is wrong).

      Снимок.PNG

       

      Thanks in advance!