# Adding time range query to one column of a Data table visualization in kibana

**URL:** https://discuss.elastic.co/t/adding-time-range-query-to-one-column-of-a-data-table-visualization-in-kibana/167600
**Category:** Kibana
**Created:** [February 8, 2019, 10:01am UTC](https://discuss.elastic.co/t/adding-time-range-query-to-one-column-of-a-data-table-visualization-in-kibana/167600 "2019-02-08T10:01:21Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [February 8, 2019, 11:18pm UTC](https://discuss.elastic.co/t/adding-time-range-query-to-one-column-of-a-data-table-visualization-in-kibana/167600/2 "2019-02-08T23:18:25Z")

</div>

Hi there, you can use the JSON input to [transform the values](https://discuss.elastic.co/t/visualize-json-input-how-to-use/75513) used in that aggregation _after_ the query has been executed, but you can't change the query itself. In other words, it won't allow you to do what you're trying to do. I think the closest you could get is to use Timelion to [perform a series difference calculation](https://rmoff.net/2016/05/23/kibana-timelion-series-calculations-difference-from-one-week-ago/). This will be in the form of a chart, not a table, but it will show difference values based on different points in time.

I hope this helps,  
CJ

---

_[View the full topic](https://discuss.elastic.co/t/adding-time-range-query-to-one-column-of-a-data-table-visualization-in-kibana/167600)._