Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a graph of bars in which it is necessary to put next to the number between parenthesis the percentage that corresponds that number.
I add graphic image.
Someone who can help me.
TRy this
For your first expression
= Dual((Count({<Dias_Comprobo={'>10'}>} VIATICANTE) & ' ' & '(' &
Num(((Count({<Dias_Comprobo={'>10'}>} VIATICANTE))*100)/Num(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)), '#,##0.00')) & ')',
Count({<Dias_Comprobo={'>10'}>} VIATICANTE))
2nd Expression
=Dual((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE) & ' ' & '(' &
Num((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)*100)/(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)),'#,##0.00')) & ')',
Count({<Dias_Comprobo={'<=10'}>} VIATICANTE))
please provide a sample application to demonstrate
thanks
regards
Marco
Maybe change your current expression to dual(current expression & '(' & percentage expression & ')',current expression)?
Hello
Many thanks Girirajsinh Vaghela, Marco Wedel and John Witherspoon for their help.
Use the expression that John suggested and I'm left as I wanted:
Can you make the percentage only show me two decimal places?
In addition to the image I added the application.
Greetings.
TRy this
For your first expression
= Dual((Count({<Dias_Comprobo={'>10'}>} VIATICANTE) & ' ' & '(' &
Num(((Count({<Dias_Comprobo={'>10'}>} VIATICANTE))*100)/Num(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)), '#,##0.00')) & ')',
Count({<Dias_Comprobo={'>10'}>} VIATICANTE))
2nd Expression
=Dual((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE) & ' ' & '(' &
Num((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)*100)/(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)),'#,##0.00')) & ')',
Count({<Dias_Comprobo={'<=10'}>} VIATICANTE))
Thank you very much Vishwarath Nagaraju with the two expressions that you provided me and I left the chart as I wanted.