Calculating Avg of a variable from ES 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 !!

@mefraimsson Could you please assist with this issue

You can’t do averages on a string field. That’s not a Grafana issue, it’s Elasticsearch limitation. Please re-index your data to use numeric response time instead.

Thanks. Your solution on the below solved this issue too