One minor point, your documents won't sort correctly (and therefore your sums will be wrong). A string of this form "[2011, 6, 7, 10, 55]" will not sort the same as the array you intended [2011, 6, 7, 10, 55].
B. On 9 June 2011 17:36, Fabio Di Bernardini <[email protected]> wrote: > I need to make a chart with hourly sum of values restricted to March. So I > don't need one number with the sum of whole March month. > > > 2011/6/9 David Hardtke <[email protected]> > >> 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 >>> >> >> >
