# Hello, now there is a scene. I need to get TOP10 data from ES and draw a histogram. The top10 data also needs to be processed and drawn into a tabular chart. How can I get the contents of the histogram for tabular chart?

**URL:** <https://discuss.elastic.co/t/hello-now-there-is-a-scene-i-need-to-get-top10-data-from-es-and-draw-a-histogram-the-top10-data-also-needs-to-be-processed-and-drawn-into-a-tabular-chart-how-can-i-get-the-contents-of-the-histogram-for-tabular-chart/288200>\
**Category:** Kibana\
**Created:** [November 2, 2021, 7:17am UTC](https://discuss.elastic.co/t/hello-now-there-is-a-scene-i-need-to-get-top10-data-from-es-and-draw-a-histogram-the-top10-data-also-needs-to-be-processed-and-drawn-into-a-tabular-chart-how-can-i-get-the-contents-of-the-histogram-for-tabular-chart/288200 "2021-11-02T07:17:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![li\_li](https://avatars.discourse-cdn.com/v4/letter/l/71e660/32.png) [@li\_li](https://discuss.elastic.co/u/li_li)\
**Post date:** [November 2, 2021, 7:17am UTC](https://discuss.elastic.co/t/hello-now-there-is-a-scene-i-need-to-get-top10-data-from-es-and-draw-a-histogram-the-top10-data-also-needs-to-be-processed-and-drawn-into-a-tabular-chart-how-can-i-get-the-contents-of-the-histogram-for-tabular-chart/288200/1 "2021-11-02T07:17:54Z")

</div>

Hello, now there is a scene. I need to get TOP10 data from ES and draw a histogram. The top10 data also needs to be processed and drawn into a tabular chart. How can I get the contents of the histogram for tabular chart?

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 2, 2021, 9:15am UTC](https://discuss.elastic.co/t/hello-now-there-is-a-scene-i-need-to-get-top10-data-from-es-and-draw-a-histogram-the-top10-data-also-needs-to-be-processed-and-drawn-into-a-tabular-chart-how-can-i-get-the-contents-of-the-histogram-for-tabular-chart/288200/2 "2021-11-02T09:15:40Z")

</div>

Hi @li_li

You can use Lens to draw both histogram and table. In Lens it is possible to switch from one visualization and the other keeping the same data table underneath: in case it is not possible a warning sign is shown with some explanation. But Histogram to table should be straightforward.

One simple flow you can have is to create a dashboard with the histogram in Lens, then clone the panel and edit the new one in Lens, changing the visualization to table. Finally save and return the the dashboard to see both.

---

<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:** [November 30, 2021, 9:15am UTC](https://discuss.elastic.co/t/hello-now-there-is-a-scene-i-need-to-get-top10-data-from-es-and-draw-a-histogram-the-top10-data-also-needs-to-be-processed-and-drawn-into-a-tabular-chart-how-can-i-get-the-contents-of-the-histogram-for-tabular-chart/288200/3 "2021-11-30T09:15:46Z")

</div>

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