# How to create a visualization with data for last two days, for yesterday and for today

**URL:** <https://discuss.elastic.co/t/how-to-create-a-visualization-with-data-for-last-two-days-for-yesterday-and-for-today/208174>\
**Category:** Kibana\
**Created:** [November 16, 2019, 4:35pm UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with-data-for-last-two-days-for-yesterday-and-for-today/208174 "2019-11-16T16:35:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![deuskars](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@deuskars](https://discuss.elastic.co/u/deuskars)\
**Post date:** [November 16, 2019, 4:35pm UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with-data-for-last-two-days-for-yesterday-and-for-today/208174/1 "2019-11-16T16:35:31Z")

</div>

I have an elasticsearch index with following fields ...  
OrderNo,StoreNo,OrderDate,Amount

I want to create a visualization that shows data like follows: (Most natural choice is  
StoreNo | Avg Amount for last two days | Avg Amount for Yesterday | Avg Amount for Today

I am able to create the visualization with StoreNo and any of the three columns (by using an appropriate filter on the date). But is there any way to get all these three Avg columns together? (I am trying both Kibana and Grafana, so if you have a suggestion for either of them, that would be a great help.)

I know how I can do this in Kibana using Vega, but I am trying to find out if there is a simpler approach.

Thanks.

- Parag

---

<div class="post-metadata">

**Author:** ![deuskars](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@deuskars](https://discuss.elastic.co/u/deuskars)\
**Post date:** [November 18, 2019, 8:48am UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with-data-for-last-two-days-for-yesterday-and-for-today/208174/2 "2019-11-18T08:48:11Z")

</div>

A correction needed. In my original post I wrote:

> [@deuskars](#):
>
> I want to create a visualization that shows data like follows: (Most natural choice is

The sentence got cut-off half way and I didn't catch that. Sorry about that. It should have been:

I want to create a visualization that shows data like follows: (Most natural choice is a Table Visualization, but I am ok if there is a different visualization that would work).

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [November 18, 2019, 9:34pm UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with-data-for-last-two-days-for-yesterday-and-for-today/208174/3 "2019-11-18T21:34:30Z")

</div>

There is no way to do this with the normal data table in kibana. You can try with the Enhanced Data Table plugin created by the community.

---

<div class="post-metadata">

**Author:** ![deuskars](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@deuskars](https://discuss.elastic.co/u/deuskars)\
**Post date:** [November 19, 2019, 8:33am UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with-data-for-last-two-days-for-yesterday-and-for-today/208174/4 "2019-11-19T08:33:57Z")

</div>

Thank you. Will try.

-- Parag

---

<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:** [December 17, 2019, 8:33am UTC](https://discuss.elastic.co/t/how-to-create-a-visualization-with-data-for-last-two-days-for-yesterday-and-for-today/208174/5 "2019-12-17T08:33:57Z")

</div>

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