Avoid fetching Active employee got Terminated when fetching Inactive Employee Data

Question

How to avoid fetching employee currently active but this employee got terminated multiple times having different assignments number when fetching inactive employee's data currently using Workforce Management - Worker Assignment Real Time Subject area

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28593/avoid-fetching-active-employee-got-terminated-when-fetching-inactive-employee-data

Hi Abdul,

Welcome to Oracle Analytics community.

You can try using RANK function:

Can someone help me how to apply Pivot in my OTBI Analysis? — Cloud Customer Connect

Thanks.