# Timelion offsetting data by two days **URL:** \ **Category:** Kibana\ **Tags:** timelion\ **Created:** [February 7, 2018, 5:19pm UTC](https://discuss.elastic.co/t/timelion-offsetting-data-by-two-days/118891 "2018-02-07T17:19:48Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Pratiksha\_Tewary](https://avatars.discourse-cdn.com/v4/letter/p/a88e4f/32.png) [@Pratiksha\_Tewary](https://discuss.elastic.co/u/Pratiksha_Tewary)\ **Post date:** [February 7, 2018, 5:19pm UTC](https://discuss.elastic.co/t/timelion-offsetting-data-by-two-days/118891/1 "2018-02-07T17:19:49Z")
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. ---
**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\ **Post date:** [February 7, 2018, 10:54pm UTC](https://discuss.elastic.co/t/timelion-offsetting-data-by-two-days/118891/2 "2018-02-07T22:54:24Z")
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](https://www.elastic.co/guide/en/kibana/current/console-kibana.html)), and a copy of the Timelion-query that illustrates the problem? ---
**Author:** ![Pratiksha\_Tewary](https://avatars.discourse-cdn.com/v4/letter/p/a88e4f/32.png) [@Pratiksha\_Tewary](https://discuss.elastic.co/u/Pratiksha_Tewary)\ **Post date:** [February 8, 2018, 6:21pm UTC](https://discuss.elastic.co/t/timelion-offsetting-data-by-two-days/118891/3 "2018-02-08T18:21:58Z")
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=\, 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. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 8, 2018, 6:22pm UTC](https://discuss.elastic.co/t/timelion-offsetting-data-by-two-days/118891/4 "2018-03-08T18:22:02Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.