UKG connector

Gunjan

I have a BI report that connects to a UKG connector. It picks up headcount at the end of the month. For some reason it skipped end of Dec 2023 headcount but is picking up Jan 2024. So now my dataset is missing Dec 2023 data. Is there a reason why such a thing could happen?

Thanks,

Gunjan

ArborRose

Did you confirm there was headcount for Dec 2023 at the time it was pulled? You may need to use something like COALESCE() if there are nulls.

Maybe check date ranges to make sure you aren't filtering it out.

ArborRose

Did you confirm there was headcount for Dec 2023 at the time it was pulled? You may need to use something like COALESCE() if there are nulls.

Maybe check date ranges to make sure you aren't filtering it out.