Succession Plan Analysis Issue

Summary:

Hello,

When trying to create a master analysis to see who are the incumbents and candidates for the succession plan (position based) the data is not separating between incumbents & candidates, they are appearing in one column which is not correct. the analysis i created is based on two subject areas :

"Workforce Succession Management - Position Plans Real Time"

"Workforce Succession Management - Plan Candidates Real Time"

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

  0 s_0,

  "Workforce Succession Management - Plan Candidates Real Time"."Candidate Details"."Candidate Ranking" s_1,