hi all.
i'm attempting to find similar purchases for a user. the volume of purchase
helps dictate the price point that they can expect. as such, i'm attempting
to determine the sum of the quantity field across all purchases per user.
i've got something like this as of yet:
facet=on&
> stats=true&
> stats.field={!tag=stats1}quantity&
> stats.facet=userId&
> facet.pivot={!stats=stats1.sum}userId&
i can see in the stats' faceting the "sum" property has what i'm looking
for. perhaps purchase #1 was a quantity of 2, purchase #2 was a quantity of
5, so the min is 2, the max is 5, and the sum is 7. that's exactly what i'm
wanting.
the facet.pivot, however, only shows me a count of how many records were a
part of that summation, so a count of 2 given my example above.
as you can see, i'd attempted to access the 'sum' property of the stats by
giving it a tag and trying to access with dot notation. no luck there.
i can use an algorithm to loop over the results of course but would love to
have the data more readily accessible when solr returns it AND even better
be able to filter query / facet query on it so that i can weed out results
that don't meet my criterion (e.g. fq=quantitySum:[* to $userQuantity])
thanks for any insights!
