# Data table with time shift

**URL:** <https://discuss.elastic.co/t/data-table-with-time-shift/315172>\
**Category:** Kibana\
**Created:** [September 26, 2022, 1:29pm UTC](https://discuss.elastic.co/t/data-table-with-time-shift/315172 "2022-09-26T13:29:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Samuele\_Mosci](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samuele_mosci/32/102983_2.png) [@Samuele\_Mosci](https://discuss.elastic.co/u/Samuele_Mosci)\
**Post date:** [September 26, 2022, 1:29pm UTC](https://discuss.elastic.co/t/data-table-with-time-shift/315172/1 "2022-09-26T13:29:54Z")

</div>

Hi, I'm using Kibana 8.4. I am trying to make a visualization (in particular a data table) where I can view documents that I do not have in a timestamp but which are present in the timestamp of the previous day. I tried with lens through differences of timestamp with time shift however since some columns that I would like to view of the data table are in string format, Kibana makes me insert them only as filters given the use of time shift but in doing so given the multitude of data that I should view it is not can make this display as I would like. Do you have any advice?

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [September 26, 2022, 1:35pm UTC](https://discuss.elastic.co/t/data-table-with-time-shift/315172/2 "2022-09-26T13:35:58Z")

</div>

Hey there,

if it's only about viewing the documents from the previous day in a dashboard, maybe you could simply change the time range for this visualization?

 ![Screenshot 2022-09-26 at 15.34.19](https://us1.discourse-cdn.com/elastic/original/3X/6/7/6736405a7d70892e705b8f792892293ad8e58e90.jpeg)

---

<div class="post-metadata">

**Author:** ![Samuele\_Mosci](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samuele_mosci/32/102983_2.png) [@Samuele\_Mosci](https://discuss.elastic.co/u/Samuele_Mosci)\
**Post date:** [September 26, 2022, 1:41pm UTC](https://discuss.elastic.co/t/data-table-with-time-shift/315172/3 "2022-09-26T13:41:29Z")

</div>

no, I have to view the documents that I don't have in the reference day. For example, today I have 10 documents and yesterday I had 15 documents, I would like to view the 5 documents miss (today and yesterday are of course in my example a reference day in the timestamp and the day before).

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [September 26, 2022, 1:53pm UTC](https://discuss.elastic.co/t/data-table-with-time-shift/315172/4 "2022-09-26T13:53:52Z")

</div>

Kibana visualizations work on aggregated data so it's not possible to view the not aggregated documents in the table (that's what discover is for). But I don't think your request is possible unless someone else has an idea?

---

<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 24, 2022, 1:54pm UTC](https://discuss.elastic.co/t/data-table-with-time-shift/315172/5 "2022-10-24T13:54:31Z")

</div>

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