incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Newson <robert.new...@gmail.com>
Subject Re: how to sum values of a view in a date range?
Date Thu, 09 Jun 2011 16:39:30 GMT
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 <fdb@altraqua.com> 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 <david@cloudant.com>
>
>> 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
>>>
>>
>>
>

Mime
View raw message