You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Set Operations trouble with visualizations

edited Aug 2, 2018 9:02PM in Reporting and Analytics for HCM 3 comments

Summary

Set Operations Cause graphs and visualizations not to work

Content

I've tried using set operations a few times for various reasons without much success.

In today's example, I'm querying and counting workers that are IN a goal plan by a derived status and trying to use a UNION to add in workers that aren't in that list. I have a derived column where workers IN the goal plan are checked for other factors to give them a status and the other set has a hard-coded value of "Not Started". Both sets are using a Count of distinct person numbers to count the workers so I assume the first data set should return all the workers in the goal plan (as filtered in the set)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!