Return-Path: 
 <solr-user-return-120678-apmail-lucene-solr-user-archive=lucene.apache.org@lucene.apache.org>
X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org
Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 0F81018319
	for <apmail-lucene-solr-user-archive@minotaur.apache.org>;
 Wed, 10 Feb 2016 10:22:00 +0000 (UTC)
Received: (qmail 76822 invoked by uid 500); 10 Feb 2016 10:21:56 -0000
Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org
Received: (qmail 76752 invoked by uid 500); 10 Feb 2016 10:21:56 -0000
Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:solr-user-help@lucene.apache.org>
List-Unsubscribe: <mailto:solr-user-unsubscribe@lucene.apache.org>
List-Post: <mailto:solr-user@lucene.apache.org>
List-Id: <solr-user.lucene.apache.org>
Reply-To: solr-user@lucene.apache.org
Delivered-To: mailing list solr-user@lucene.apache.org
Received: (qmail 76741 invoked by uid 99); 10 Feb 2016 10:21:56 -0000
Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Feb 2016 10:21:56 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org)
 with ESMTP id 139B8C01AB
	for <solr-user@lucene.apache.org>; Wed, 10 Feb 2016 10:21:56 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 0.572
X-Spam-Level: 
X-Spam-Status: No, score=0.572 tagged_above=-999 required=6.31
	tests=[KAM_LAZY_DOMAIN_SECURITY=1, MIME_QP_LONG_LINE=0.001,
	RP_MATCHES_RCVD=-0.429] autolearn=disabled
Received: from mx1-eu-west.apache.org ([10.40.0.8])
	by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new,
 port 10024)
	with ESMTP id 9bHFxjxw5dbl for <solr-user@lucene.apache.org>;
	Wed, 10 Feb 2016 10:21:55 +0000 (UTC)
Received: from mail1.ams.nl.openindex.io (mail1.ams.nl.openindex.io
 [141.105.125.41])
	by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with
 ESMTP id D916931ADE
	for <solr-user@lucene.apache.org>; Wed, 10 Feb 2016 10:21:54 +0000 (UTC)
Received: from localhost (localhost [127.0.0.1])
	by mail1.ams.nl.openindex.io (Postfix) with ESMTP id F23BE1210FC
	for <solr-user@lucene.apache.org>; Wed, 10 Feb 2016 10:21:53 +0000 (UTC)
Received: from mail1.ams.nl.openindex.io ([127.0.0.1])
	by localhost (mail1.ams.nl.openindex.io [127.0.0.1]) (amavisd-new,
 port 10024)
	with ESMTP id b9TwXokKQpFd for <solr-user@lucene.apache.org>;
	Wed, 10 Feb 2016 10:21:53 +0000 (UTC)
Received: from mail1.ams.nl.openindex.io (localhost [127.0.0.1])
	by mail1.ams.nl.openindex.io (Postfix) with ESMTP id DB0B41210E5
	for <solr-user@lucene.apache.org>; Wed, 10 Feb 2016 10:21:53 +0000 (UTC)
Subject: Json faceting, aggregate numeric field by day?
From: =?utf-8?Q?Markus_Jelsma?= <markus.jelsma@openindex.io>
To: =?utf-8?Q?solr-user?= <solr-user@lucene.apache.org>
Date: Wed, 10 Feb 2016 10:21:53 +0000
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-Mailer: Zarafa 7.2.1-51838
X-Original-To: 
Message-Id: <zarafa.56bb0f41.2a92.1b95d0c611082a52@mail1.ams.nl.openindex.io>

Hi - if we assume the following simple documents:

<doc>
  <date name=3D"time">2015-01-01T00:00:00Z</date>
  <int name=3D"value">2</int>
</doc>
<doc>
  <date name=3D"time">2015-01-01T00:00:00Z</date>
  <int name=3D"value">4</int>
</doc>
<doc>
  <date name=3D"time">2015-01-02T00:00:00Z</date>
  <int name=3D"value">3</int>
</doc>
<doc>
  <date name=3D"time">2015-01-02T00:00:00Z</date>
  <int name=3D"value">7</int>
</doc>

Can i get a daily average for the field 'value' by day=3F e.g.

<lst name=3D"value">
  <double name=3D"2015-01-01T00:00:00Z">3.0</double>
  <double name=3D"2015-01-02T00:00:00Z">5.0</double>
</lst>

Reading the documentation, i don't think i can, or i am missing it completely. But i just want to be sure.

Many thanks,
Markus