How to display percent in a stacked bar chart?

[jip31]

hi

I try to display percent in my bar chart like this but it doesnt works

| chart count as total over sig_application by sig_transaction 
| eval total=0 
| foreach count* 
    [ eval total=total + <<FIELD>>] 
| foreach count* 
    [ eval <<FIELD>>=round((<<FIELD>>/total)*100,1)] 
| fields - total

is anybody can help please?

[ITWhisperer]

What fields do you get from 

| chart count as total over sig_application by sig_transaction

[jip31]

what do you mean exactly?

[ITWhisperer]

What are the fields/column called?

Your foreach count* assumes that that they all start with count?

[jip31]

you are right

it's not the case...

it miss | rename * as count*

[ITWhisperer · Accepted solution]

Try something like this

| chart count as total over sig_application by sig_transaction 
| rename * as count*
| rename countsig_transaction as sig_transaction
| addtotals fieldname=total count* 
| foreach count* 
    [ eval <<FIELD>>=round((<<FIELD>>/total)*100,1)] 
| fields - total

[jip31]

thanks to your help but i think its not a good idea to use it because its not really explicit in my chart

[ITWhisperer]

So you also have a column called countsig_transaction?

[jip31]

I just have a column countsig_app