Talent Review Prior and Latest N-Box Analysis
Summary:
I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box.
I created analysis but when I use the RCOUNT( person_number), it is just coming as a consecutive sequence instead of showing the rcount per employee number.
Also, I need to use this row count in the Logical SQL to check the change in Talent Review. I have created the sql ( old_new_rating.txt) , but the rowcount is not correct so probably the Logical SQL is also failing.
Any help on this please.