I want to visualize a trend of appearing of new users over time. Username is a text field. I decided to use Area Visualization with Cumulative Sum and Unique count of username aggregations. I specified it in Metrics. Then there was a hint to use Date Histogram or Histogram in aggregation in Buckets. So now I have a timestamp on the X-axis.
I see that the values on the graphs are too big because it makes the sum of unique users per periods and ignore intersections. I mean I want to make sums of unique users from the last period and new (who appear for the first time) users.
Any ideas, please? Maybe JSON advanced script is needed?
Thank you!
Thank you for the idea. I'm trying to use cumulative sum because I'm interested in growth rate. For further analysis of periods when we had a lot of (or a few) new users
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.