4 Replies Latest reply: Mar 20, 2018 11:04 AM by Youssef Belloum RSS

    How do you add multiple measurement in a pie chart?

    Zaid Alemam

      Hi,

       

      I'm trying to get my pie chart to display multiple measurements.

       

      I'm trying to measure whether my SLA's are on target or past SLA, based on date calculation.

       

      They're also sorted by Large effort and Small effort or if the values are null then "Project not assigned"

       

      So I'm trying to display the following

      =if([L0 Estimate Completion Date]<=[L0 Estimate Due Date] and [Estimation SLA Code] = 'Small', 'Small Project Within SLA',

       

       

      if([L0 Estimate Completion Date]>[L0 Estimate Due Date] and [Estimation SLA Code] = 'Small', 'Small Project Past SLA',

       

       

      if([L0 Estimate Completion Date]<=[L0 Estimate Due Date] and [Estimation SLA Code] = 'large', 'Large Project Within SLA',

       

       

      if([L0 Estimate Completion Date]>[L0 Estimate Due Date] and [Estimation SLA Code] = 'large', 'Large Project Past SLA',

       

       

      'Project not assigned date or size'))))

       

      My code doesnt throw back an error, but the data its displaying is wrong.

       

      Any help would be appreciated.

       

      Thanks,

       

      Zaid