# Visualize count of unique identities over time

**URL:** <https://discuss.elastic.co/t/visualize-count-of-unique-identities-over-time/125647>\
**Category:** Kibana\
**Created:** [March 26, 2018, 4:47pm UTC](https://discuss.elastic.co/t/visualize-count-of-unique-identities-over-time/125647 "2018-03-26T16:47:57Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [March 26, 2018, 9:42pm UTC](https://discuss.elastic.co/t/visualize-count-of-unique-identities-over-time/125647/2 "2018-03-26T21:42:10Z")

</div>

I've seen this question before and unfortunately I don't think there's a good answer.

One possible way, although it looks quite ugly, is to do your Unique Count metric, and then to `Split Chart` instead of `Split rows`. I _think_ it's doing what you want but looks terrible;

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/e/0e58bf14a68080d82130f2ca23bff684165843cc.png)

You could click the little arrow under the visualization to open the "spy panel" and look at the results to see if it looks like it's doing the right thing;

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/f/3ff1a162925841e1b2766cbee0a6245490da4477.png)

Here's another long post where we tried to get the same thing (and failed);

> [@Cumulative Sum regardless of time interval](https://discuss.elastic.co/t/cumulative-sum-regardless-of-time-interval/96677/17):
>
> Hi Chris I feel it's up to how people are defining cusum. For me it could be a cumulative number based on the whole time series. It equals to sum an auto date histogram of a certain metric from begging of the specified timefield until now and when date range filter is applied, it's just slice a piece of data from timeline instead of re-calculate it based on the date range filter. There might be needs for both cases, I just hope if kibana team could add a variable in cusum function to make both …

Regards,  
Lee

---

_[View the full topic](https://discuss.elastic.co/t/visualize-count-of-unique-identities-over-time/125647)._