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.
Looker support here, thanks for reaching out. From the picture you provided, it looks like you might find this Discourse post on calculating subtotals to be helpful: Subtotals in Looker
If you follow the steps in this article to create subtotal rows for each date, then you should be able to filter the query to only get the subtotal rows and then make your visualization from that.
If you have any questions about getting this set up, feel free to ask and we’d be happy to help.