Join multiple subject areas in Analytics
Join multiple subject areas to have an outer joint result.
My users want a dashboard to show the percentage of the employees who set up annual career goals. I am building an analytics that needs to provide a total of all employees and a total of employees who set up their goals.
The subject area 'Workforce Management-Worker Assignment Realtime' can provide the total of all employees(FTEs).
The subject area 'Workforce Goals - Goal Status Overview Real time' can provide only the employees who set up the goals but not the employees who haven't done so.
I added two subject areas in the analytics and expected to get a list of two groups of employees described above. It is like an outer joint if using SQL. But the result of joining two subject areas cut off the 2nd group employees.