9336

Exclude results from Elasticsearch / Kibana based on aggregation value

Question:

Is it possible to exclude results based on the outcome of an aggregation?

In other words, I have aggregated on a Term and a whole bunch of results appear in a data table ordered in descending order by the count. Is it possible to configure kibana / elasticsearch to exclude results where count is 1 or less. (Where count is an aggregation).

I realise I can export the raw data from the data table visualization and delete those records manually through a text editor or excel. But I am trying to convince my organization that elasticsearch is a cool new thing and this is one of their 1st requirements...

Answer1:

You can exclude the result from the search by applying a filter here a sample that can be helpfull.

"query": { "bool": { "filter": { "range": { "Your_term": { "gte": 1 } } } }

Recommend

  • Tween JS basics on three JS cube
  • kibana read only dashboard
  • How to create filebeat index pattern in kibana?
  • Elasticsearch 2.4 nodes does not form cluster with ConnectTransportException
  • searchguard for SSL communication in ELK
  • Index ID identification in Elasticsearch/Kibana visualization
  • Send Kubernetes cluster logs to AWS Elasticsearch
  • WP7 - issues with Horizontal scrolling Listbox
  • Sorting elements of vector where each element is a pair [duplicate]
  • Removing an XWPFParagraph keeps the paragraph symbol (¶) for it
  • Regex takes a long time to complete
  • Linq distinct based on two columns
  • How to test labels in QTP
  • OpenMP for dependent variables
  • Rails 4 order by virtual attribute
  • How do I generate data for Google Visualizations on the server using WebSharper
  • How to sort things out in ListView?
  • R Leaflet Legend: specify order instead of alphabetical
  • Deploying pre-encrypted configuration files to a production environment
  • Instanciate service on startup in Angular2
  • get passwords from chrome
  • Laravel lmutator $this->attributes return 'Undefined index: id'
  • How to set an entity field that does not exist on the table but does exists in the raw SQL as an ali
  • Count from each distinct date, fill in missing dates with zero
  • Using Generics on right hand side in Java 6?
  • How do I retrieve the user information of a user authenticated with Apache's mod_ldap?
  • Getting media player state in windows phone 7
  • Using Sax parsing to edit and write XML in VB6
  • How do I configure context broker accept post requests from my remote sensor?
  • Breeze - Deleted Items nav properties bug
  • Django: Count of Group Elements
  • javaw.exe and eclipse startup problems
  • swift auto completion not working in Xcode6-Beta
  • Sending data from AppleScript to FileMaker records
  • MySQL WHERE-condition in procedure ignored
  • Rearranging Cells in UITableView Bug & Saving Changes
  • Rails 2: use form_for to build a form covering multiple objects of the same class
  • need help with bizarre java.net.HttpURLConnection behavior
  • How to get NHibernate ISession to cache entity not retrieved by primary key
  • Observable and ngFor in Angular 2