Turnover Beast Mode: Avg Distinct Count / Days in date range
I am attempting to create a Turnover Rate beast mode that would take the Average Distinct Count of employee IDs, then divide it by the number of days in the user selected date range. I've tried the following syntax, but I receive an error: Raw syntax: AVG(COUNT(DISTINCT CASE WHEN Team Member status = 'Active' OR Team…
