7 Replies Latest reply: Dec 15, 2016 5:16 AM by yogesh jamddhade RSS

    Pie Chart expression to show 2 values

    Cliff Clayman

      I am trying to create a Pie Chart to show me the count of ID's that exceed limits and then the remainder that are within the limits.  Here is the expression to get the Count for the ID's that exceed the limits:

       

      =Count(If([MLimit] > 5000 Or [TLimit] > 2500, [TransID]))

       

       

      How can I also get the remainder that are within the limits to display on the pie chart?