I'm creating a report to show time sheet submissions globally. I need to calculate the total number of active employees in a region.
I have unique employee IDs (Employee #) with a region (REGION) on each record and each employee record also has a Termination Date field. If the termination date field is blank, they're still active and considered for compliance calculations.
How do I create a distinct count of unique employees for each region, where the regions are:
Japan
China
Americas
EMEA
AUSTRALIA
Any help would be greatly appreciated.
Hi @David Hafer ,
If you're only showing one region on your sheet, then just applying a filter should work. If you're trying to do a comparison between them then you might need to include the region in the calculation(s). Eg.
COUNTD(IF ISNULL([Termination Date]) AND [Region]="EMEA" THEN [Employee NBR] END)
Hopefully that helps! Otherwise we might need to see an example of your visualization. Thanks!
Best,
Bryce
