How do I get sum of a field in solr 4.8

Question

This is my response data:

"response": {
    "numFound": 2,
    "start": 0,
    "docs": [
    {
      "total_amount": 10,
      "id": "2"
    },
    {
      "total_amount": 10,
      "id": "1"
    }
  ]
}

I want to get sum of total_amount. I tried facet query also. But I did't get sum. I got some blog on this but that is for solr 5.1. http://yonik.com/solr-facet-functions/

Facet functions are available only in 5.1 and above. This cannot be done natively in solr 4.8. — Prabhu Velayutham, May 27 '15 at 05:29
Thank you. I have decided to use 5.1. Where I can achieve this functionality. — Mukesh Jeengar, May 27 '15 at 06:38
To get sum for `total_amount` field you can use the stats component: http://wiki.apache.org/solr/StatsComponent — Manjunath H, May 29 '15 at 12:08

score 12 · Accepted Answer · answered Jun 01 '15 at 21:55

You can use the stats functionality to get this information. Just put the followed parameters in your query:

stats=true&stats.field=total_amount

Your response will be like that:

"response": {
    "numFound": 2,
    "start": 0,
    "docs": [
      {
        "id": "1",
        "total_amount": 15
      },
      {
        "id": "2",
        "total_amount": 12
      }
    ]
  },
  "stats": {
    "stats_fields": {
      "total_amount": {
        "min": 12,
        "max": 15,
        "count": 2,
        "missing": 0,
        "sum": 27,
        "sumOfSquares": 369,
        "mean": 13.5,
        "stddev": 2.1213203435596424,
        "facets": {}
      }
    }

Note that you have lots of information around the total_amount field including the sum.

How do I get sum of a field in solr 4.8

1 Answers1