# How to get unique count before and after split rows on the same table

**URL:** <https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535>\
**Category:** Kibana\
**Created:** [June 19, 2019, 7:41pm UTC](https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535 "2019-06-19T19:41:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![leeyu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leeyu/32/48561_2.png) [@leeyu](https://discuss.elastic.co/u/leeyu)\
**Post date:** [June 19, 2019, 7:41pm UTC](https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535/1 "2019-06-19T19:41:41Z")

</div>

Hi all,

I am working with some data contain the record of user\_id and event\_id.

I want to get the percentage of the unique user encounter each event.

i.e. (unique user encount event 1) / (unique user) .

I know I can do the calculation with Datasweet plug-in.

but I am not sure how to get both unique counts at the same time.

Thanks.

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [June 19, 2019, 9:30pm UTC](https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535/2 "2019-06-19T21:30:59Z")

</div>

This probably isn't something you'll be able to do with the data table in Kibana, but you may be able to accomplish it using Canvas. Do you have Canvas in your Kibana installation?

---

<div class="post-metadata">

**Author:** ![leeyu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leeyu/32/48561_2.png) [@leeyu](https://discuss.elastic.co/u/leeyu)\
**Post date:** [June 19, 2019, 10:15pm UTC](https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535/4 "2019-06-19T22:15:06Z")

</div>

Hi Lukas,

After trying the canvas, I think canvas cannot do what I want.

But still, thanks for the advice.

---

<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 17, 2019, 10:15pm UTC](https://discuss.elastic.co/t/how-to-get-unique-count-before-and-after-split-rows-on-the-same-table/186535/5 "2019-07-17T22:15:14Z")

</div>

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