Hello! I'm trying to get a line chart that shows the calculations of DAU/MAU and WAU/MAU (DAU = Daily Active Users, WAU = Weekly, MAU = Monthly). Thanks to another user's help, I was able to get a graph showing DAU and I could do the same thing to get a graph with WAU, but what I'm really interested in is the ability to graph that formula. To give a little context - every user activity is logged as a single record (with a userId value) in an index. The graphs group those records per day unique'd by userId and then plot them on a line chart. Is there a way to take that value and divide it by the MAU in a single graph?
Here's an example if my above explanation wasn't clear:
Imagine I have 1000 daily active users today, 2000 yesterday, and 1500 the day before. I can easily graph that, but what I really want to do is take each day and divide it by the total number of active users in the previous 30 days. So for today, I'd divide 1000 by the number of active users in the past 30 days, yesterday I would divide 2000 by the total number of users active in the past 30 days shifted over 1 day, and so on.
Let me know if that makes sense or if I can clarify anything!
Host: Elastic Cloud
Elastic Version: 8.7