Timelion offsetting data by two days

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.

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?

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.

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