3 Replies Latest reply: Dec 6, 2017 6:24 PM by Vishwarath Nagaraju RSS

    Pie Chart %?

    Cassandra Baqir

      As you can see from the highlight below, there is 1 out of 51 tickets in PPAG but it's showing as 65%. My expression is

       

      =((Sum(
      Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})
      *
      e({<COM_CAT ={'ERC - Assigned'} >})
      *
      e({<COM_CAT ={'ERC - Routing'} >})
      *
      e({<COM_CAT ={'ERC - Routing - Agenda'} >})
      *
      p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}
      distinct DEFECT_ID), PRIMARY_DECISION_BODY,DEFECT_ID) ))
        /
        (
      Sum(
      Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})
      *
      e({<COM_CAT ={'ERC - Assigned'} >})
      *
      e({<COM_CAT ={'ERC - Routing'} >})
      *
      e({<COM_CAT ={'ERC - Routing - Agenda'} >})
      *
      p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}
      total distinct DEFECT_ID), PRIMARY_DECISION_BODY,DEFECT_ID) )) * 100)

      12-6-2017 2-39-25 PM.jpg:

        • Re: Pie Chart %?
          Vishwarath Nagaraju

          Are you looking for this?

          Capture.PNG

          Try this?

          =Num((Sum(

          Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})

          *e({<COM_CAT ={'ERC - Assigned'} >})

          * e({<COM_CAT ={'ERC - Routing'} >})

          * e({<COM_CAT ={'ERC - Routing - Agenda'} >})

          * p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}

          distinct DEFECT_ID), PRIMARY_DECISION_BODY) ))

           

           

          /

           

           

          (Sum(

          Aggr(Count({$<DEFECT_ID = e({<CUR_STATUS ={'Closed' , 'Denied' , 'Dismissed' , 'Closed - Maintenance'} >})

          *e({<COM_CAT ={'ERC - Assigned'} >})

          * e({<COM_CAT ={'ERC - Routing'} >})

          * e({<COM_CAT ={'ERC - Routing - Agenda'} >})

          * p({<COM_CAT ={'Decision Body(s) - Design'}>}) >}

          total distinct DEFECT_ID), PRIMARY_DECISION_BODY) )) ,'#,##0.00%' )