Chart command.

[sandeepmakkena]

index=aos_transaction

| chart count by payments, geo
| addtotals col=t
| sort -Total
| head 10

I want to display only top 10 payments with geo breakdown. when I use the above command my total is also showing in the bar chat.

[somesoni2]

Try this

index=aos_transaction 
| chart count by payments, geo
| addtotals
| sort -Total
| head 10

[sandeepmakkena]

I alredy tried that but, the problem is when displaying as chart it is including total in the chart. I just want it to be used for sorting.