5 Replies Latest reply: Jan 27, 2017 12:12 PM by Oleg Troyansky RSS

    Sotring 2-dimensional bar chart

    eeacrw cewdbr

      Hi all!

       

      Please help me to sort a 2-dimensional bar chart in QSense:

       

      Dim1 - 1st dimension.

      Dim2 - 2nd.

      2nd dimension has 3 different values: high, average, low.

      Count(Dim2) is used to get values for a chart   (measure).

      1) I need to sort 1st dimension - based on total count of Dim2's of each Process

      2) And I need to sort bars inside each process as follows:

      left bar - high

      middle bar - average

      right bar - low

       

      RandomData:

      Load * Inline [

      ID, Dim1, Dim2

      1, Process1, high

      2, Process1, high

      3, Process1, high

      4, Process1, average

      5, Process1, average

      6, Process1, average

      7, Process1, high

      8, Process1, low

      9, Process1, low

      10, Process1, high

      11, Process2, high

      12, Process2, high

      13, Process2, low

      14, Process2, average

      15, Process3, average

      16, Process3, average

      17, Process3, high

      18, Process3, low

      19, Process3, low

      ];

       

      Thanks!