Any plans for aggregation queries (SUM)?

I am currently using Algolia and am interested in App Search.

However, one important feature from Algolia that my team need is the aggregation feature done on facets (especially the sum feature). My use case is I search items, each one having a price associated to it, and need the sum of results' price when displaying results.

Is there any plan to have this available in App Search soon? Or is there a way to achieve it with the current feature set? I can't seem to find anything on it...

Do you have any suggestion?

Thanks for your help.

Hi @Alexandre_Boucher. I don't think I fully understand what you are asking about. Could you give me an example?

Of course! Let's say I have the following results when I query App Search:

[{
  "name": {
    "raw": "A"
  },
  "amount": {
    "raw": 10
  }
}, {
  "name": {
    "raw": "B"
  },
  "amount": {
    "raw": 15
  }
}]

I would like to be able to get the total of the field amount. In this case, with these 2 results, it would be 10 + 15 = 25

Oh that is interesting. And no, we don't have anything that would support that right now. Something like this would of course be possible with Elasticsearch, but not in App Search: https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-sum-aggregation.html

Do you have any plans to support this kind of feature in AppSearch soon?

Not to my knowledge.