Is it possible to filter individual Count aggregations? I'm trying to get a count of all items that were opened in a month vs all items that were closed in a month. Each document will have an OPEN_DT field and if closed a CLOSE_DT.
If I split the series by the CLOSE_DT below it causes chaos. Unique counts of the two fields breaks cause some documents could have the same open/closed dates. Would the filters aggregation work here? Any help or advice would be appreciated. Would really prefer not to have two separate bar charts with date histograms of each field.
In my example I've used a Filter by for all products which price is above 100 and there's a discount applied. A similar Count metric can be built with the opposite Filter by for all products cheaper than 100 with a discount, and visualize something like this:
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.