Calculating Avg of a variable from ElasticSearch datasource

Hi,

I have the json data in Elastic Search as below.

{
    "responsetime": "100",
    "operation": "api1"
  },
  {
    "responsetime": "200",
    "operation": "api2"
  },
  {
    "responsetime": "110",
    "operation": "api1"
  }

I want to display this in a table with the below columns.

OperationName
AvgTime
MinTime
MaxTime

Can you please assist !

Here is my Grafana screen. I was trying to bring Avg column first !!