# Help with Kibana displaying percentage by group

**URL:** <https://discuss.elastic.co/t/help-with-kibana-displaying-percentage-by-group/236372>\
**Category:** Kibana\
**Created:** [June 9, 2020, 3:13pm UTC](https://discuss.elastic.co/t/help-with-kibana-displaying-percentage-by-group/236372 "2020-06-09T15:13:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bob\_herdsman](https://avatars.discourse-cdn.com/v4/letter/b/3ab097/32.png) [@bob\_herdsman](https://discuss.elastic.co/u/bob_herdsman)\
**Post date:** [June 9, 2020, 3:13pm UTC](https://discuss.elastic.co/t/help-with-kibana-displaying-percentage-by-group/236372/1 "2020-06-09T15:13:59Z")

</div>

Hi!  
I'd like to visualize my data in a certain way with Kibana and I don't know if it is possible or how to do it. I'd appreciate any help because I'm new to Kibana. I've attached a screenshot covering my current and, of course, invalid way of trying to achieve it with Filter Ratios.  
Basically I have a field named action in my json which can currently have two different values: startSession or startVideoStreaming. I have a field called mediaSessionId which is a session GUID. In the example that can be seen on the screenshot I have 3 entries, 1 entry with sessionId 1 that has the action type of startSession, and 2 entries of sessionId 2, 1 with startSession action and 1 with startVideoStreaming. I'd love to see the following percentages:  
startSession: 100%  
startVideoStreaming: 50%  
Basically I'd like something like this: (count of some action / count of unique mediaSessionIds). Thanks!

 ![Screenshot 2020-06-09 at 17.06.02](https://us1.discourse-cdn.com/elastic/original/3X/1/1/1184ba437837ad54aea7a67a833d8835685747bb.png)

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [June 23, 2020, 7:16pm UTC](https://discuss.elastic.co/t/help-with-kibana-displaying-percentage-by-group/236372/2 "2020-06-23T19:16:06Z")

</div>

Your approach would work, but I think you need to change the actual query text because it's using Lucene syntax. Try `_exists_:title` instead of `title:*`- the asterisk approach is what we support with KQL, but this section doesn't use 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:** [July 21, 2020, 7:16pm UTC](https://discuss.elastic.co/t/help-with-kibana-displaying-percentage-by-group/236372/3 "2020-07-21T19:16:08Z")

</div>

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