3 Replies Latest reply on Nov 15, 2016 3:58 PM by Shinichiro Murakami

    Sort a stacked bar chart by segment where segment is defined by an 'if' statement

    Michael Moore

      I am trying to sort descending the stacked bar chart below by the 'Adopted' segment in blue. I have found an example in this forum on how to do that using a parameter. I've attached the example called Example.twbx. The workbook I'm having the problem on is also attached and is called the Usage.twbx. There are two key differences between the Example and Usage workbooks. First the Usage workbook is trying to sort on a table calculation that shows the percent of Adopted vs. Not Adopted for each District. Second, the Adoption field is created using the following calculation:

       

      IF [# of Files] > 0

          THEN "Adopted"

          ELSE "Not Adopted"

      END

       

      Any help would be greatly appreciated!

       

      Usage.png