Pie Chart %?

[cbaqir]

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)

:

[vishsaggi · Accepted solution]

Are you looking for this?

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%' )

[cbaqir]

was it just missing the num format?

[vishsaggi]

No your aggr function in the expression has field DEFECT ID as one of the aggr field, but in your chart you are using only has PRIMARY_DECISION_BODY as your dimension so removed that DEFECT_ID.