Bar chart issue

[paulwalker]

Hi Community

I have a bar chart and it works well, but If I choose a specific bar that shows "No data on display".

without selection working fine as below...

while select any bar, as below..

Could you please assist.

[MayilVahanan · Accepted solution]

Hi @paulwalker 

Try like below

DUAL(MUPC_FAMILY_SHORT_TITLE &' '& (NUM(((Avg(BASE_SALARY)-AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE)))
/
AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE))), '##.##%')),

((Avg(BASE_SALARY)-AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE)))
/
AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE))))

[paulwalker]

Thanks Mayil 🙂