# Terms daily percentage in Data Table visualization

**URL:** <https://discuss.elastic.co/t/terms-daily-percentage-in-data-table-visualization/171925>\
**Category:** Kibana\
**Created:** [March 12, 2019, 10:41am UTC](https://discuss.elastic.co/t/terms-daily-percentage-in-data-table-visualization/171925 "2019-03-12T10:41:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fabio-sama](https://avatars.discourse-cdn.com/v4/letter/f/b9e5f3/32.png) [@Fabio-sama](https://discuss.elastic.co/u/Fabio-sama)\
**Post date:** [March 12, 2019, 10:41am UTC](https://discuss.elastic.co/t/terms-daily-percentage-in-data-table-visualization/171925/1 "2019-03-12T10:41:44Z")

</div>

Hi there!

I'm struggling to achieve the following result.

Let's say I have a field "Result" that can be equal to A, B or C.  
Everyday I obviously have numerous hits, each with its own Result.

Now, is there a way (possibly using Data Table) to compute the percentage of a certain occurrence of a field Result per day?

To put it simple, right now I can manage to have something like:

DAY RESULT COUNT  
2019-03-11 A 27  
2019-03-11 B 33  
2019-03-11 C 12  
2019-03-10 A 39  
2019-03-10 B 21  
2019-03-10 C 20  
...

But what I'd like to have is something like:

DAY RESULT PERCENTAGE  
2019-03-11 A 37,5  
2019-03-10 A 48,75

With the percentages computed as (27/(27+33+12))\*100 and (39/(39+21+20))\*100

Is there a way to accomplish such a task?

Thank you!

---

<div class="post-metadata">

**Author:** ![jen-huang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jen-huang/32/74327_2.png) [@jen-huang](https://discuss.elastic.co/u/jen-huang)\
**Post date:** [March 12, 2019, 5:12pm UTC](https://discuss.elastic.co/t/terms-daily-percentage-in-data-table-visualization/171925/2 "2019-03-12T17:12:35Z")

</div>

Hi, percentage in data table isn't currently possible. [There is an open enhancement issue for it.](https://github.com/elastic/kibana/issues/19489) You can check the issue for a possible alternative.

---

<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 9, 2019, 5:12pm UTC](https://discuss.elastic.co/t/terms-daily-percentage-in-data-table-visualization/171925/3 "2019-04-09T17:12:39Z")

</div>

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