Scusami, I thought you needed average, not sum. As David pointed out, the
built-in _sum function works flawlessly for you, then.
Querying the view, I would rather use &startkey=[2011,3]&endkey=[2011,3,{}],
without the inclusive_end.
Gabor
On Thursday, June 9, 2011 at 6:26 PM, David Hardtke wrote:
> Hi Fabio,
>
> This should work. You can use the _sum builtin as reduce:
>
> "reduce":"_sum"
>
> You then need to query your view with the proper group level and a
> startkey and endkey:
>
> GET
> db/_design/power/_view/watt?group_level=2&startkey=[2011,3]&endkey=[2011,4]&inclusive_end=false
>
> That gives you the sum for the month of March.
>
>
>
> On 06/09/11 09:06, Fabio Di Bernardini wrote:
> > Il 09/06/2011 17:18, Fabio Di Bernardini ha scritto:
> > > If I have a map function emitting a timestamp as key ad a number as
> > > document, how to get sum of values selecting a date range?
> >
> > More datails here:
> > http://stackoverflow.com/questions/6294794/how-to-sum-values-of-a-view-in-a-date-range-using-couchdb
> >
