I am developing a dashboard that require total paid and unpaid FTE in a fiscal year or calendar year quarter. My dataset contains a row for each active employee in a month, meaning that an employee who is active in all three months of a quarter have three rows in the dataset. My calculation only need one active row in a quarter not three.
Here's a sample dataset of three employees (A, B, C) each with FTE of 1 in the first quarter of 2021
Jan - A = 1, B = 1, C = 1
Feb - A = 1, B = 1, C = 1
Mar - B = 1, C = 1
Expected total paid FTE for the three employees in first quarter is 3 and not 8.
If there's a document that will assist me on this, please direct me to it.
If you duplicate the date column and apply a Quarter format, you could visualize the data that way. You could also use this Quarter column in a time hierarchy like Year>Quarter>Date that the user could drill into.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.