# Daily comparison in kibana data table

**URL:** <https://discuss.elastic.co/t/daily-comparison-in-kibana-data-table/223462>\
**Category:** Kibana\
**Created:** [March 13, 2020, 7:46am UTC](https://discuss.elastic.co/t/daily-comparison-in-kibana-data-table/223462 "2020-03-13T07:46:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![shwesinhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shwesinhan/32/78663_2.png) [@shwesinhan](https://discuss.elastic.co/u/shwesinhan)\
**Post date:** [March 13, 2020, 7:46am UTC](https://discuss.elastic.co/t/daily-comparison-in-kibana-data-table/223462/1 "2020-03-13T07:46:09Z")

</div>

Hi community,  
Is there any way to create daily comparison data table or any plot in kibana.  
eg: ![pivot](https://us1.discourse-cdn.com/elastic/original/3X/5/f/5fdc2d19dcd1892be9842212e323d826b5cc83e0.png)

I can not use custom plugin because I use kibana with aws elasticsearch. 😅  
Appreciate for any idea.

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [March 13, 2020, 8:24am UTC](https://discuss.elastic.co/t/daily-comparison-in-kibana-data-table/223462/2 "2020-03-13T08:24:46Z")

</div>

You can create this type of chart with the `Heatmap` vis in Visualize.

---

<div class="post-metadata">

**Author:** ![shwesinhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shwesinhan/32/78663_2.png) [@shwesinhan](https://discuss.elastic.co/u/shwesinhan)\
**Post date:** [March 16, 2020, 2:41am UTC](https://discuss.elastic.co/t/daily-comparison-in-kibana-data-table/223462/3 "2020-03-16T02:41:16Z")

</div>

Thanks @flash1293.

1. Is that possible to remove `_all` below heatmap?

![_all](https://us1.discourse-cdn.com/elastic/original/3X/0/e/0e890898fe94b95f803f29d405c3dc9b7d32aa59.png)

1. Also if i play date range in heatmap vis, date is show multiple times. but it's ok Last 7 date search. like last 6 days or 3 days = dates show multiple, last 7days search= dates show correctly.  
 ![hm](https://us1.discourse-cdn.com/elastic/original/3X/9/8/98bed758e7a1046407ca5e00c5f888a9d6e46949.png)  
What's wrong with that. Like data point is fixed distance? Does anybody know how to solve it?

---

<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:** [April 13, 2020, 2:41am UTC](https://discuss.elastic.co/t/daily-comparison-in-kibana-data-table/223462/4 "2020-04-13T02:41:17Z")

</div>

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