Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of carl.bourne@me.com designates
 17.158.236.242 as permitted sender)
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; CHARSET=US-ASCII
From: Carl Bourne <carl.bourne@me.com>
Subject: Summary view for Pie Charting
Message-id: <08180A01-8DC0-491C-8976-B75BBB5F95F4@me.com>
Date: Thu, 20 Sep 2012 01:06:29 +0100
To: "user@couchdb.apache.org" <user@couchdb.apache.org>

Hi,

I'm trying to build a summary view for a pie chart based on a document count within date ranges as shown below. 

The map function is basically working, except I need to get the "emit(XX-Days, 1);" part to write a variable label in the place of the XX-Days. e.g. 30-Days,60-Days,90-Days. However, I can't seem to work out a way to do this. 

Any suggestions would be much appreciated.


Map Function:

function(doc){
    var now = new Date((new Date()).getTime());
    var thirty_days_from_now = new Date((new Date()).getTime() + 30*24*60*60*1000);
    var sixty_days_from_now = new Date((new Date()).getTime() + 60*24*60*60*1000);
    var ninty_days_from_now = new Date((new Date()).getTime() + 90*24*60*60*1000);
    var expire = Date.parse(doc.date.expire)

    
    var exps = [thirty_days_from_now, sixty_days_from_now, ninty_days_from_now];

for (r in exps){
   if (expire >= now && expire <= (exps[r])){
   emit(XX-Days, 1);
     
   }
 }
return;
}

Reduce Function:

_count

Regards,

Carl