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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 966 Connectors
- 254 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 75 SQL DataFlows
- 499 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 360 Beast Mode
- 19 Variables
- 481 Automate
- 101 Apps
- 376 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive