Population Counts - Year over Year
Summary: I am looking to create an analysis, which will be connected to a dashboard, to report population counts year over year. I have included an example below:
August 1st 2022 - 14,500 total employees
August 1st 2021 - 13,000 total employees
August 1st 2020 - 12,000 total employees
I have leveraged the standard assignment count within OTBI, however not sure how to insert date(s) to capture what I need.