Unable to Visualize data in Kibi


(Gangadhar Dantusetty) #1

My Logstash config file :

input {
file {
path => "C:\Users\dantusga\Desktop\ganga.csv"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}

filter {
csv {
separator => ","
columns => ["emp_id","E_NAME","DEPT","Designation","Salary","Gender","LOB","DOB"]
}

date {
match => ["DOB", "yyyy-MM-dd"]
target => ["DOB"]
}
if [emp_id] == "emp_id" {
drop { }
}

}

output {
elasticsearch {
action => "index"
hosts => "localhost"

 index => "logstash-test1-"

}
stdout {}
}

In Kibi

the result is

It is working fine(able to visualize ) without using date filter . But it is considering DOB field as string. But I want DOB as date. Please help me ..


(Shaunak Kashyap) #2

Hi @Gangadhar_dantusetty,

Kibi is a fork of Kibana so its possible its creators have changed some functionality from Kibana. Still, what you are describing looks like vanilla Kibana functionality so lets see if we can figure it out here.

It is working fine(able to visualize ) without using date filter

Referring to the last screenshot, you are actually asking Kibana/Elastisearch to aggregate (group by) the DOB field, not filter by it.

Are you saying that if you aggregate by another field, results are being shown on the right?

But it is considering DOB field as string. But I want DOB as date.

Hmmm... that is odd, especially since in the 2nd screenshot DOB is shown as a date. Referring to the 3rd screenshot, could you expand the Field drop down and paste a screenshot of that here, showing the DOB field in the list?

Thanks.


(system) #3

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