5 Replies Latest reply: May 8, 2015 1:47 AM by balkumar chandel RSS

    Sort chart by two expressions

      I have a simple bar chart with one dimension: Supplier.

      And one dimension: Percentage of Good Deliveries.

       

      At the moment I am sorting by expression: the percentage of good deliveries for the supplier (set analysis). However if a supplier has delivered 1 order, and another supplier has delivered 500; then I want the supplier with 500 to come above the supplier with 1 order.

       

      Is there a way to first sort by percentage of good deliveries, (and if the percentage is the same as another value in the chart e.g. two suppliers are 100%) then sort by count (number of orders)?

       

       

      So: Sort by percentage of good deliveries

      If the percentage is the same as another supplier

      then sort the matching values by order quantity

       

       

      Thanks