23 Replies Latest reply: Sep 7, 2016 3:00 PM by Cliff Clayman RSS

    Creating a Pie Chart from Straight Table

    Cliff Clayman

      I would like to create a Pie Chart from some data I prepared in a Straight Table.  However, I would only like to chart a portion of the data.

       

       

      POs.JPG

       

       

      I only want to chart the ratio between the values on the PO row.  How can I limit the data in this straight table and turn it into a Pie Chart?  I had to create a calculated Dimension for the Po vs No PO field.

       

      =If(Len([PO]) = 0,'No PO','PO')