Ranking the table results

[Poonam]

I have a data table as below:

I need to rank the customers based on count of transactions. How to do this.

[Orbulon]

As I understand it, you need to use bucket_sort aggregation, something like this:

{ "rank": {
      "bucket_sort": {
        { "sort": [
          {
            { "transactions": {
              { "order": { "desc"
            }
          }
        ],
        }, "size": 100
      }
    }
  }

But here about kibana, I haven’t really figured out the visualization.