Employee Retention Rate over time
Hi,
I'm trying to calculate employee retention rate over time (in quarters ideally). The data that I'm pulling in has each employee's start date and end date (if they've left).
The equation for retention I think I want to use is:
(headcount (Q-1) - sum(leavers))/headcount (Q-1)
Any ideas how to do this? I'm struggling to use cummulative totals and operate on them.
0
Comments
-
Can you provide a few sample rows of your data set?
My guess is that something like this should work:
(
SUM(`headcount`) - SUM(`leavers`)
)
/
SUM(`headcount`)But that would depend entirely on how your dataset is built
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 304 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 773 Beast Mode
- 74 App Studio
- 43 Variables
- 726 Automate
- 185 Apps
- 466 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive