How to use Filter in DateHistogram Facet?


(vijuitech) #1

Hi,
Is there any method to use Facet Filter in Date Histogram Facet?

Cheers!

George


(Shay Banon) #2

Yes, you can simply add a facet_filter to it.

On Sat, May 19, 2012 at 6:32 PM, George Viju vijuitech@gmail.com wrote:

Hi,
Is there any method to use Facet Filter in Date Histogram Facet?

Cheers!

George


(vijuitech) #3

Thanks Shay!

I tried the Facet filter for the Two Tones Positive and Negative. But
I am getting the Total data for each date range here (Not getting
Positive and Negative count Separately). It is not filtering

It is getting as

For the same date range For Positive.

"createddaterange1" : {
"_type" : "date_histogram",
"entries" : [ ]
},

For the same date range For Negative.. But the count I got here is
the (Combination of Both Positive and Negative)
"createddaterange2" : {
"_type" : "date_histogram",
"entries" : [ {
"time" : 1337212800000,
"count" : 34,
"min" : 1.337269645E12,
"max" : 1.33729302E12,
"total" : 4.5467295833E13,
"total_count" : 34,
"mean" : 1.3372734068529412E12
}, {
"time" : 1337299200000,
"count" : 1,
"min" : 1.33737948E12,
"max" : 1.33737948E12,
"total" : 1.33737948E12,
"total_count" : 1,
"mean" : 1.33737948E12
},

How can I get the Positive and Negative counts separately?

Thanks!

Cheers!

George!

On May 21, 2:58 am, Shay Banon kim...@gmail.com wrote:

Yes, you can simply add a facet_filter to it.

On Sat, May 19, 2012 at 6:32 PM, George Viju vijuit...@gmail.com wrote:

Hi,
Is there any method to use Facet Filter in Date Histogram Facet?

Cheers!

George


(vijuitech) #4

Hi,
Which type of Filter did DateHistogram Facet support? Is it
possible to use Term Filter in DateHistogram Facet?

cheers!

George

On May 21, 10:49 am, George Viju vijuit...@gmail.com wrote:

Thanks Shay!

I tried theFacetfilterfor the Two Tones Positive and Negative. But
I am getting the Total data for eachdaterange here (Not getting
Positive and Negative count Separately). It is not filtering

It is getting as

For the samedaterange For Positive.

"createddaterange1" : {
"_type" : "date_histogram",
"entries" : [ ]
},

For the samedaterange For Negative.. But the count I got here is
the (Combination of Both Positive and Negative)
"createddaterange2" : {
"_type" : "date_histogram",
"entries" : [ {
"time" : 1337212800000,
"count" : 34,
"min" : 1.337269645E12,
"max" : 1.33729302E12,
"total" : 4.5467295833E13,
"total_count" : 34,
"mean" : 1.3372734068529412E12
}, {
"time" : 1337299200000,
"count" : 1,
"min" : 1.33737948E12,
"max" : 1.33737948E12,
"total" : 1.33737948E12,
"total_count" : 1,
"mean" : 1.33737948E12
},

How can I get the Positive and Negative counts separately?

Thanks!

Cheers!

George!

On May 21, 2:58 am, Shay Banon kim...@gmail.com wrote:

Yes, you can simply add a facet_filter to it.

On Sat, May 19, 2012 at 6:32 PM, George Viju vijuit...@gmail.com wrote:

Hi,
Is there any method to useFacetFilterinDateHistogramFacet?

Cheers!

George


(Shay Banon) #5

You can use any filter in the facet_filter element. You previous mail
really assumed too much regarding my knowledge of your app... . If you
don't understand something, gist a simple recreation (see
http://www.elasticsearch.org/help), that would be the fastest way to help.

On Tue, May 22, 2012 at 11:48 AM, George Viju vijuitech@gmail.com wrote:

Hi,
Which type of Filter did DateHistogram Facet support? Is it
possible to use Term Filter in DateHistogram Facet?

cheers!

George

On May 21, 10:49 am, George Viju vijuit...@gmail.com wrote:

Thanks Shay!

I tried theFacetfilterfor the Two Tones Positive and Negative. But
I am getting the Total data for eachdaterange here (Not getting
Positive and Negative count Separately). It is not filtering

It is getting as

For the samedaterange For Positive.

"createddaterange1" : {
"_type" : "date_histogram",
"entries" : [ ]
},

For the samedaterange For Negative.. But the count I got here is
the (Combination of Both Positive and Negative)
"createddaterange2" : {
"_type" : "date_histogram",
"entries" : [ {
"time" : 1337212800000,
"count" : 34,
"min" : 1.337269645E12,
"max" : 1.33729302E12,
"total" : 4.5467295833E13,
"total_count" : 34,
"mean" : 1.3372734068529412E12
}, {
"time" : 1337299200000,
"count" : 1,
"min" : 1.33737948E12,
"max" : 1.33737948E12,
"total" : 1.33737948E12,
"total_count" : 1,
"mean" : 1.33737948E12
},

How can I get the Positive and Negative counts separately?

Thanks!

Cheers!

George!

On May 21, 2:58 am, Shay Banon kim...@gmail.com wrote:

Yes, you can simply add a facet_filter to it.

On Sat, May 19, 2012 at 6:32 PM, George Viju vijuit...@gmail.com
wrote:

Hi,
Is there any method to useFacetFilterinDateHistogramFacet?

Cheers!

George


(system) #6