This seems like it should be simple — but I’m having some trouble getting it.
A user on our platform can be either “active” or “inactive” (if, for example, their account expired, they were removed from their account by an administrator, etc).
When a user is added to our platform, we add “status: active” to their profile. When they’re deleted/removed/etc their profile is updated so that “status: inactive”.
The problem: how do I show the number of active users at some point in the past? I’d like to be able to graph historical event activity against historical active users on our platform. Is this even possible? I note that according to this article on the knowledge base “Because user profile properties only store the most recent value, cohorts involving user profile properties will use the current value for those properties (even if the value changed over time).”
Is there another way that I’m missing?