UKG connector
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
-
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! **0
Answers
-
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! **0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 95 Manage
- 92 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive