# How use DataTable or any component of Visualization to build below report

**URL:** <https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840>\
**Category:** Kibana\
**Created:** [June 26, 2020, 10:58am UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840 "2020-06-26T10:58:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jaytran](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@jaytran](https://discuss.elastic.co/u/jaytran)\
**Post date:** [June 26, 2020, 10:58am UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840/1 "2020-06-26T10:58:38Z")

</div>

Hi all,

I have below data:

```
	"hits" : [
  {
    "_index" : "test-2020.05",
    "_source" : {
      "@version" : "1",
      "status" : "DONE",
      "level" : "ERROR"
    }
  },
  {
    "_index" : "test-2020.05",
    "_source" : {
      "@version" : "1",
      "status" : "PROCESSING",
      "level" : "ERROR"
    }
  },
  {
    "_index" : "test-2020.05",
    "_source" : {
      "@version" : "1",
      "status" : "WAITING",
      "level" : "ERROR"
    }
  },
  {
    "_index" : "test-2020.06",
    "_source" : {
      "@version" : "1",
      "status" : "WAITING",
      "level" : "ERROR"
    }
  }
]

```

Now I want to build a report like below:  
| Processing | Done | Waiting|  
| 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |

```
 The numbers are displayed in report is count of status

```

Anyone tell me know how to use DataTable or any component of Visualization to build above report. I'm a new one, I don't have much experience in Visualization.  
Thank you for any responses.

---

<div class="post-metadata">

**Author:** ![Anirudhan](https://avatars.discourse-cdn.com/v4/letter/a/91b2a8/32.png) [@Anirudhan](https://discuss.elastic.co/u/Anirudhan)\
**Post date:** [June 26, 2020, 12:59pm UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840/2 "2020-06-26T12:59:07Z")

</div>

If you split by rows for the field status in data Table.  
| Processing |1 |  
| Done | 1|  
| Waiting | 2 |.  
But it can be achieved by using a plugin called **kibana-enhanced-table**.

---

<div class="post-metadata">

**Author:** ![Jay\_Tran](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jay_tran/32/47985_2.png) [@Jay\_Tran](https://discuss.elastic.co/u/Jay_Tran)\
**Post date:** [June 26, 2020, 3:41pm UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840/3 "2020-06-26T15:41:11Z")

</div>

thank you for your response.  
so there is no way to use Visualization?

---

<div class="post-metadata">

**Author:** ![mykael](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@mykael](https://discuss.elastic.co/u/mykael)\
**Post date:** [June 27, 2020, 2:23pm UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840/4 "2020-06-27T14:23:48Z")

</div>

Try using 'Split chart' by status as the buckets in some of the visualizations . Use Count as the other axis. Might need to search a bit to get one you like.

---

<div class="post-metadata">

**Author:** ![Jay\_Tran](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jay_tran/32/47985_2.png) [@Jay\_Tran](https://discuss.elastic.co/u/Jay_Tran)\
**Post date:** [June 28, 2020, 3:05pm UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840/5 "2020-06-28T15:05:46Z")

</div>

Thanks, I tried, it works

---

<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:** [July 26, 2020, 3:05pm UTC](https://discuss.elastic.co/t/how-use-datatable-or-any-component-of-visualization-to-build-below-report/238840/6 "2020-07-26T15:05:47Z")

</div>

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