Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
:
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%' )
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%' )
was it just missing the num format?
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.