Client Churn ETL
I am trying to generate a data set for client churn by month and I'm running into an issue. I need to be able to calculate total clients (running total) up to a specific month and total lost clients that month.
The final data should look something like this. You can imagine there were 5 new clients in November, 10 new clients in December and 25 new clients in January.
I run into an issue when trying to calculate running total number of clients. I can't seem to find a way to use rank & window or group by to be able to calculate the total number of clients before a given date. I can easily see how many clients were added within a given month but I cannot seem to achieve a running total.
How might I accomplish this?
Comments
-
To do a running total with the rank & window tile, choose Sum and then choose unbounded and 0 following and sort by date ascending.
I'm not sure how you are determining lost clients, so you may need to explain more how that is determined if you need help on that.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
That worked! Thanks!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive