Hi Everyone - I am trying to figure out how to create a visualization to show the number of active goals per user over time.
Background: We are running a pilot for an app that allows users to create goals with a start date and end date.
Question to answer: How many goals do people pursue at the same time?
Desired Visualization: Number of active goals per active user over time.
- Note: If a user has not created any goals, or has completed all their goals, they don’t appear on that particular day. Ie, if a user has 0 active goals on a given day, we exclude them for that day’s calculations
Let me upload a table and chart that maps out what I’m thinking for how to approach this. The open question in my mind is if I can graph only the subtotals for each time period, but not the data rows themselves.