Combining date_histogram with statistics facets

I'm sure that has probably been asked already but my searching didn't come
up with anything (I really apologize if it has been).

I'm looking to do some analytics with ES. I was wondering if there was any
way I could leverage the features of date_histogram while still getting
additional statistics for each interval. The desired output would be
something like:

[
{
"key": "day 1",
"sum": 234,
"count": 12
},
{
"key": "day 2",
"sum": 353,
"count": 15
}
]

Is it possible to get a sum/average/anything other than a count through the
date_histogram facet?

Thanks

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Hi Colin

Have you tried it?

The date histogram outputs the following data:

  • "time" - starting time of this bucket
  • "count" - total number of docs in this bucket
  • "min" - min of value_field
  • "max" - max of value_field
  • "mean" - mean of value_field
  • "total" - sum of value_field
  • "total_count" - total number of docs in this bucket with a value in
    value_field

Clint

On 16 May 2013 01:54, Colin Morelli colin.morelli@gmail.com wrote:

I'm sure that has probably been asked already but my searching didn't come
up with anything (I really apologize if it has been).

I'm looking to do some analytics with ES. I was wondering if there was any
way I could leverage the features of date_histogram while still getting
additional statistics for each interval. The desired output would be
something like:

[
{
"key": "day 1",
"sum": 234,
"count": 12
},
{
"key": "day 2",
"sum": 353,
"count": 15
}
]

Is it possible to get a sum/average/anything other than a count through
the date_histogram facet?

Thanks

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

I'm an idiot, completely skipped over the "value_field" option.

Thanks Clint.

On Thursday, May 16, 2013 5:19:36 AM UTC-4, Clinton Gormley wrote:

Hi Colin

Have you tried it?

The date histogram outputs the following data:

  • "time" - starting time of this bucket
  • "count" - total number of docs in this bucket
  • "min" - min of value_field
  • "max" - max of value_field
  • "mean" - mean of value_field
  • "total" - sum of value_field
  • "total_count" - total number of docs in this bucket with a value in
    value_field

Clint

On 16 May 2013 01:54, Colin Morelli <colin....@gmail.com <javascript:>>wrote:

I'm sure that has probably been asked already but my searching didn't
come up with anything (I really apologize if it has been).

I'm looking to do some analytics with ES. I was wondering if there was
any way I could leverage the features of date_histogram while still getting
additional statistics for each interval. The desired output would be
something like:

[
{
"key": "day 1",
"sum": 234,
"count": 12
},
{
"key": "day 2",
"sum": 353,
"count": 15
}
]

Is it possible to get a sum/average/anything other than a count through
the date_histogram facet?

Thanks

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.