Employee Retention Rate over time
Options
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
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive