# Visualize future date in timelion?
**URL:** https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830
**Category:** Kibana
**Tags:** timelion
**Created:** [March 24, 2017, 2:36am UTC](https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830 "2017-03-24T02:36:47Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [March 24, 2017, 2:36am UTC](https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830/1 "2017-03-24T02:36:47Z")
Hello
I am using Kibana to show project KPI state. I know that I could achieve my goal in **Linechart** which is to draw a line chart of PV line for next 4 month.
Since timelion has more flexibility with the chart , I want to use timelion instead but it seems that **future date** is not displaying .
My query is below,
`$ser=.es(index='project-hours-dashboard-*', q='Name:渡辺 AND ReportWeek:["2017-03-01" TO *]', metric='sum:TotalAcutualHours', timefield='ReportWeek' ) ($ser).label(渡辺稼働) .static(40).label(標準稼働時間)`
I have two timestamp fields **@timestamp** and **ReportWeek**. I want to use @timestamp field when querying and Report Week for x-axis of line chart. ReportWeek includes dates up to end of July.
Is it possible to display future dates on the chart?
---
### Author:  [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)
#### Post date: [March 24, 2017, 2:49pm UTC](https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830/2 "2017-03-24T14:49:03Z")
I tried to do something similar and was able to get it to work (if I correctly understand your goal). Make sure you set your time range in the upper right corner to an absolute time in the future.
Here is my sample data I'm using:
Let me know if this helps, or if I am misunderstanding.
---
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [March 24, 2017, 11:28pm UTC](https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830/3 "2017-03-24T23:28:27Z")
@Stacey_Gammon
Thank you for the reply.
The chart itself is the one I want to see but the timefilter is not correct.
I should have clarified this part more. Sorry about not giving you enough information.
Below is the snippet of \_source of arbitrary record from the index I am using.
I have two timestamp fields ,
**@timestamp** is the indexed time which logstash automatically gernates.
**ReportWeek** is the weeks within the project. This goes all the way up to end of June.
```
"_source": {
"path": "/etc/logstash/csv/project-hours-dashboard/2017-03-24-at.csv",
"MajorDeliverable": "xxxx",
"@timestamp": "2017-03-24T02:16:00.497Z",
"Phase": "phase2",
"TotalAcutualHours": 0,
"@version": "1",
"host": "visual",
"ReportWeek": "2017-07-24",
"message": "Elasticxxxx\t2017-07-24\t8\t0\txxxx\tphase2",
"TotalScheduledHours": 8,
"tags": [
"project-hours-dashboard"
],
"Name": "xxxx"
},
```
My final goal is to integrate the chart from _timelion_ into dashboard so that I can visualize with other vis components. Below is the line chart I have implemented with **linechart vis component**. You can see that timefilter filters the events by **@timestamp**. And _linechart_ uses the **ReportWeek** for the x-axis using datetime histogram.
So if my understanding is correct, **timelion is not able to draw a chart when the context of time for time filter and x-axis is different?**
---
### Author:  [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)
#### Post date: [March 27, 2017, 1:14pm UTC](https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830/4 "2017-03-27T13:14:21Z")
Ah, I understand now. You can have a timelion chart on a dashboard where the x-axis date field is different than the default date field for the time picker in the upper right, but the interval will always be the same. I don't believe there is any way to accomplish this today, where you can set the time field in a timelion chart, _and_ the time interval for it to display.
You can see here I have two different charts using two different fields for the x axis, but because the interval is still dictate by the upper right time picker, they won't show results at the same time.
Your request sounds similar to this issue, which was closed: [https://github.com/elastic/timelion/issues/126](https://github.com/elastic/timelion/issues/126)
---
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [March 28, 2017, 7:56am UTC](https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830/5 "2017-03-28T07:56:19Z")
@Stacey_Gammon
Got it. Thanks.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 25, 2017, 7:56am UTC](https://discuss.elastic.co/t/visualize-future-date-in-timelion/79830/6 "2017-04-25T07:56:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.