I am trying to find a way to count number of rows per month (spanning over 3 years and counting) to get the total number employees for each month in variable form.
The data structure is set in a way that the number of rows should be equal to the number of active employees as of a certain snapshot date.
I am not sure if I should do this in ETL or Beastmode and how!
Would greatly appreciate any advice :)