Combining date_histogram with statistics facets

Elastic Stack Elasticsearch
1

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.

2

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.

3

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.