How to give WHERE condition in data table


#1

I've a data table with count as one of the columns. How do i set a condition on the column to display rows of data only if count > 50.


(Bhavya R M) #2

You can use a scripted field here:
https://www.elastic.co/guide/en/kibana/current/scripted-fields.html

Create a scripted field which will set to the value of count when its >50 and then display that in your aggs.

Thanks,
Bhavya


#3

Okay great thanks Bhavya.
could you give one example for scripted fields,if possible


#4

suppose i want to select the only those rows which have color blue


(system) #5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.