Quote:
Originally Posted by capink
The formulas action already has a "mean" function that should be able to handle things like this. You can combine it with from_search() function to get the desired result. See the help on formulas action for more.
|
That is a good solution. "from_search" and "for" work together well in this case. Get the list of categories of interest, loop through them searching for books, compute the mean, then construct the result.