Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Customer Retention Chart using Vega-Lite

Topic Labels: Extensions
802 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi!

I have some customer data that includes the date they signed up & the date they canceled. Each row is a customer. I want to calculate my customer retention and have done it using google sheets. My current solution uses a column for week1, week2, week3…etc a series of IF statements to determine if the customer was retained (1) or churned (0). Then, my summary row at the bottom can tell me my churn rate.

What I’m wondering is two things: how can I transpose those summaries from being spread across columns to something I can chart in Vega lite.

OR

Is there a way to avoid creating all of these extra columns and running these cumulative summaries in JSON/Vega lite

Screen Shot 2021-02-03 at 12.22.57 PM

0 Replies 0