Is it possible to use sum, average, etc. for a specific field?
If we have a hash data like the following:
id
value1 =>numeric data
value2 =>numeric data
…
How can we have the sum of all value1 data?
How can we have the average of all value2 data?
Query like below :
FT.AGGREGATE idx * Filter “…” sum(value1)
or
FT.AGGREGATE idx * Filter “…” AVG(value2)
FT.SEARCH idx [query] sum(value1)