Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've got a pie chart with its numbers and % (used count and ticket relative option for one expression, for the other only count)
I wanted to change it to bar chart and highlight value (percentage)
My formula is
DUAL(Num(count( {<MyVar1 *= {1}>} MyVar1),'#.') & ' (' & Num(count( {<MyVar1 *= {1}>} MyVar1)/count(TOTAL MyVar1 *= {1}>} MyVar1),'0.0%')&')',count( {<MyVar1 *= {1}>}MyVar1))
I can see slight discrepancies between charts in percentage
Pie chart (its accurate)
Bar chart
Looks like DUAL expression takes into consideration null values, because there is 3.2% for full values and when I add that, then its 100%.