Visualize count of unique identities over time

[LeeDr (Lee Drengenberg)]

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;

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;

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

Cumulative Sum regardless of time interval

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