Calculating Week on Week customer retention
Hi, i need assistance calculating week on week customer retention using a domo beastmode on a transaction dataset. Dataset appends new transaction based on the transaction date so a single customer has multiple rows of transaction distinguished by transaction data
Answers
-
What kind of data do you have? Do you have customer acquired/customer lost dates? You can join to a date dimension and calculate per customer per month if a customer is active or not.
0 -
You can calculate the beginning day of the week using a beast mode:
`date` - INTERVAL (DAYOFWEEK(`date`)-1) DAY
Alternatively though I recommend using a date dimension table with custom offsets to make this easier so you can see how many you have from the prior week and calculate week over week differences. I've written on this here:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Its a transaction table. if customer A makes a purchase today , a row is created with date of transaction.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive