Timelion returns incorrect data

I am using Kibana 5.6 Timelion right now and found some weird behavior.
I am setting an absolute time 2019-10-29 00:00:00.000 to 2019-10-29 23:59:59.999. And split rows by date histogram with daily interval. The data table returns me 1 data which is as expected. But in timelion will give me 2 data, both are the same value from the result of data table. Please see below screenshot.
Screenshot from Data Table

Screenshot from Timelion

And here is the payload from timelion. Hope this will help.
{"sheet":[".es(index='sa-gec.com_prereturn_join', timefield='PreReturn.creation_ts', q=\"(Vars_PreReturn.lad_segment:(lad_seg1 or lad_seg2)) AND (_exists_:PostReturn.creation_ts)\").label('LAD Daily Count').bars(15)"],"extended":{"es":{"filter":{"bool":{"must":[{"match_all":{}}],"must_not":[]}}}},"time":{"from":"2019-10-29T07:00:00.000Z","to":"2019-10-30T06:59:59.999Z","mode":"absolute","interval":"1d","timezone":"America/Los_Angeles"}}

Could you please give me some clue how can I make timelion work as expected? Like return only one day data?

Thanks a lot.

That might be from the timelion handling partial buckets. I'm not aware on how it was in 5.6 as that is a couple years old, but you could try and add ".trim(0,0)" at the end of your query.

Hi @Marius_Dragomir,

Really sorry to reply you this late....
I checked newer version 6.8 have the same issue. Even adding .trim(0.0) doesn't help.
It actually very easy to reproduce.

I changed the time frame to absolute from 2019-11-27 00:00:00.000 to 2019-11-27 23:59:59.999.
And then add a very simple query like:
.es(index='bot_log', timefield='ts').bars(15).trim(0,0). And interval to 1d.

You will see 2 bars on the chart shows. Both have same value.
When I try exactly same from data table and I got only 1 response which should be correct behavior.

Just wondering what should I do on timelion to get the same behavior.

Thanks a lot!

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