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

# Pie Chart %?

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)

:

• ###### Re: Pie Chart %?

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

• ###### Re: Pie Chart %?

was it just missing the num format?

• ###### Re: Pie Chart %?

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.