Timelion offsetting data by two days

Elastic Stack Kibana
1

Hello,

I am trying to display one specific week's data in one of my Timelion graphs. However, when I make the bucket span wider (change from 1h to 1d), the entire data is being offset by 2 whole days. When I put my mouse pointer at any point on the graph, it shows the data point of two days after that day (for e.g., it shows 0 for Jan 24th, 2018 when in the dataset, the 0 is the value for Jan 26th, 2018). Is there any way to avoid this?

Thanks.

2

hi @Pratiksha_Tewary,

Not sure what's going on. Can you provide a specific example that isolates the problem?

For example, can you provide a script with some example data that we can paste into the Kibana-console (https://www.elastic.co/guide/en/kibana/current/console-kibana.html), and a copy of the Timelion-query that illustrates the problem?

3

Thank you for your response. Following is the dataset that I have pushed to my ES instance. (The three fields are - Product ID, Quantity On Hand, Date

Product_ID Qty_on_hand Date
60003 1000 1/1/2018
60003 347 1/2/2018
60003 37 1/3/2018
60003 1000 1/4/2018
60003 2093 1/5/2018
60003 0 1/6/2018
60003 4888 1/7/2018
60003 -10 1/8/2018
60003 5433 1/9/2018
60003 5000 1/10/2018
60003 140 1/11/2018
60003 360 1/12/2018
60003 200 1/13/2018
60003 200 1/14/2018
60003 939 1/15/2018
60003 1000 1/16/2018
60003 4925 1/17/2018
60003 0 1/18/2018
60003 190 1/19/2018
60003 350 1/20/2018
60003 400 1/21/2018
60003 285 1/22/2018
60003 4453 1/23/2018
60003 1383 1/24/2018
60003 384 1/25/2018
60003 0 1/26/2018
60003 923 1/27/2018
60003 0 1/28/2018
60003 -15 1/29/2018
60003 1000 1/30/2018
60003 0 1/31/2018

Here is the exact action I performed:

  1. In Timelion, I entered the following expression: .es(index=<index_name>, metric=avg:Qty_On_Hand)
  2. Set the default Timelion date field to: Date
  3. I changed the bucket to: 1d
  4. Changed the time frame to Jan 24th, 2018 to Jan 31st, 2018

On doing this, you will see Qty_On_Hand as 923 for 1/25/2018 in the graph, when actually it is supposed to be 923 for 1/27/2018.

Kindly try this out and let me know if its the same problem for you.

Thanks.