# 5.5.0 Filter by date and keep historical data

**URL:** https://discuss.elastic.co/t/5-5-0-filter-by-date-and-keep-historical-data/99426
**Category:** Kibana
**Created:** [September 5, 2017, 12:33pm UTC](https://discuss.elastic.co/t/5-5-0-filter-by-date-and-keep-historical-data/99426 "2017-09-05T12:33:13Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Dudas](https://avatars.discourse-cdn.com/v4/letter/d/58956e/32.png) [@Dudas](https://discuss.elastic.co/u/Dudas)
#### Post date: [September 5, 2017, 12:33pm UTC](https://discuss.elastic.co/t/5-5-0-filter-by-date-and-keep-historical-data/99426/1 "2017-09-05T12:33:13Z")

</div>

I need to plot some data in differents columns: the first one shows data of a specific date and the second one shows the average historical data (for example the average of some field).

When I plot it in a dashboard, I'll want to filter by date (for example, showing data for August 1st OR 2nd OR... ) on the first column.  
Can I do it without changing the data showed in the column with the historical data?

Example: I have a Vertical Bar Chart.  
Column A has info of August 1st.  
Column B has the average of all historical data.  
When I put it on my **dashboard** , I want the column A to show info about September 5th but keep my historical data on column B.

How can I do it?

---

<div class="post-metadata">

### Author: ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [September 5, 2017, 3:54pm UTC](https://discuss.elastic.co/t/5-5-0-filter-by-date-and-keep-historical-data/99426/2 "2017-09-05T15:54:26Z")

</div>

Timelion, [https://www.elastic.co/guide/en/kibana/current/timelion.html](https://www.elastic.co/guide/en/kibana/current/timelion.html), is designed for problems like these and will allow you to compare current data with historical data

---

<div class="post-metadata">

### Author: ![Dudas](https://avatars.discourse-cdn.com/v4/letter/d/58956e/32.png) [@Dudas](https://discuss.elastic.co/u/Dudas)
#### Post date: [September 12, 2017, 12:09pm UTC](https://discuss.elastic.co/t/5-5-0-filter-by-date-and-keep-historical-data/99426/3 "2017-09-12T12:09:30Z")

</div>

I've been looking for some information about timelion but I have some questions:

I saw that I can make a timelion dashboard visualize unaffected by dashboard filters using  
.es(kibana=false)

But this is my problem:

1. I have a dashboard
2. In that dashboard I have 2 visualizes
3. Visualize 1 is timelion's with .es(kibana=false)
4. In visualize 2, I filter by date
5. Visualize 1 is filtered by date too

Do you know how can I get the first visualization unaffected by this?

Thanks

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 10, 2017, 12:09pm UTC](https://discuss.elastic.co/t/5-5-0-filter-by-date-and-keep-historical-data/99426/4 "2017-10-10T12:09:42Z")

</div>

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