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.
Try this
index=aos_transaction
| chart count by payments, geo
| addtotals
| sort -Total
| head 10
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.