help in Dual and Y-Axis

[ali_hijazi]

Hello got a bar chart with the following expression:

dual(num(COUNT(DISTINCT VERSION_ID)),num(count(DISTINCT VERSION_ID)/count(TOTAL DISTINCT VERSION_ID),'#,##0.00%'))

the result is fine; I want to display number of versions and on the y-axis display the percentage of number of version by patch to total number of versions

I want to display 0%, 2%, 4%, .... 18%

Please advise

[sushil353]

Try This:

dual(num(COUNT(DISTINCT VERSION_ID),'#,##0.00%'),num(count(DISTINCT VERSION_ID)/count(TOTAL DISTINCT VERSION_ID),'#,##0.00%'))

if that is not working then goto Number tab and check the option for show in percent

HTH

Sushil

[ali_hijazi]

no this will put on the first bar for example 6400%

and if I go to number tab I won't get the count but the ratio in percent on the bars

[ali_hijazi · Accepted solution]

I added instead 2 expressions

one to show the ratio in percent and another to display the count but I remove the check box on bar so as not to display another bar