# Data table visualization in Kibana **URL:** \ **Category:** Kibana\ **Created:** [May 16, 2018, 5:02am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028 "2018-05-16T05:02:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![vikas.joinme](https://avatars.discourse-cdn.com/v4/letter/v/4491bb/32.png) [@vikas.joinme](https://discuss.elastic.co/u/vikas.joinme)\ **Post date:** [May 16, 2018, 5:02am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/1 "2018-05-16T05:02:53Z")
I want to display Top WebService Actions by Avg Time in data table . could you please tell me how to implement using data table visulaization Below is the sample data : i need four column ( web service action , count ,Avg time , total time) |Web Service Action| Count | Avg Time | Total Time | |Demo action | 1,746 | 81,768,562| ---
**Author:** ![Dvikas](https://avatars.discourse-cdn.com/v4/letter/d/a9adbd/32.png) [@Dvikas](https://discuss.elastic.co/u/Dvikas)\ **Post date:** [May 16, 2018, 9:22am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/2 "2018-05-16T09:22:47Z")
you can do by going to visualisation-\>data table select the index there provide the details under buckets aggregation as terms and thn in field webservice Action order by term ,use asc or desc order provide the size. next select terms in sub aggregation under advanced ,thn in fields give avg time order by metric:count,give asc or desc and provide the size.you will get three columns webserviceAction,AvtTime and count. ---
**Author:** ![vikas.joinme](https://avatars.discourse-cdn.com/v4/letter/v/4491bb/32.png) [@vikas.joinme](https://discuss.elastic.co/u/vikas.joinme)\ **Post date:** [May 16, 2018, 10:59am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/3 "2018-05-16T10:59:28Z")
I am not getting the desired output. i have selected the index under datatable 1. In metrics : i have selected count from drop-down 2)In Buckets , i have clicked on split rows a) clicked on aggregation ,selected Terms, in fields, web service action and order by metric: count order by desc b) clicked on sub Buckets: click on split row then selected sub aggregation sub aggregation : terms Field : Webserviceaction order by : custome metric aggreegation : average order descending ---
**Author:** ![Dvikas](https://avatars.discourse-cdn.com/v4/letter/d/a9adbd/32.png) [@Dvikas](https://discuss.elastic.co/u/Dvikas)\ **Post date:** [May 16, 2018, 2:34pm UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/4 "2018-05-16T14:34:29Z")
b) do the following in select Field: Avg Time. and order by : metric ---
**Author:** ![vikas.joinme](https://avatars.discourse-cdn.com/v4/letter/v/4491bb/32.png) [@vikas.joinme](https://discuss.elastic.co/u/vikas.joinme)\ **Post date:** [May 17, 2018, 9:01am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/5 "2018-05-17T09:01:03Z")
thanks, i am able to get the result now. I have got one more requirement (Top 20 Frequent Requests by Avg Time Taken (\>= 10 Occurrences)) could you please tell me how to give WHERE condition in KIbana data table ( i want only those row which have count greater than 10) ---
**Author:** ![Dvikas](https://avatars.discourse-cdn.com/v4/letter/d/a9adbd/32.png) [@Dvikas](https://discuss.elastic.co/u/Dvikas)\ **Post date:** [May 17, 2018, 10:14am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/6 "2018-05-17T10:14:25Z")
you can do in dsl query but not in visualization I think.I will check and come back to you. ---
**Author:** ![vikas.joinme](https://avatars.discourse-cdn.com/v4/letter/v/4491bb/32.png) [@vikas.joinme](https://discuss.elastic.co/u/vikas.joinme)\ **Post date:** [May 17, 2018, 10:22am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/7 "2018-05-17T10:22:08Z")
ok thanks. i will wait for your reply ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 14, 2018, 10:22am UTC](https://discuss.elastic.co/t/data-table-visualization-in-kibana/132028/8 "2018-06-14T10:22:09Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.