Splunk Search
Highlighted

Chart command.

Contributor

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.

Tags (2)
0 Karma
Highlighted

Re: Chart command.

SplunkTrust
SplunkTrust

Try this

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

Re: Chart command.

Contributor

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.

0 Karma