UKG connector

Options
Gunjan
Gunjan Member
in Connectors

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

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories