Rating level name showning in two rows one is empty

AjayKumar Maddipati

Summary:

Hi Team,

we have performnce documet rating level name column but its shown as below, in single column shown as two rows of each employee . any one help on how to short that issue and i applied column properties Value Suppression but no change.

Thanks,

Ajay

Content (required):

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

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

Bhaskar Konar

Hi @AjayKumar Maddipati,

Have you tired using Pivot Table and put the Rating Level Name in Measure and change the aggregation level as first / last / max etc.?

If possible attach the report xml / catalog here so that it can be looked into more details.

Hope this help.

Cheers,

Venkat Koduvayur-Oracle

Hi @AjayKumar Maddipati

I presume you are using Workforce Performance - Performance Rating Real Time subject area to build this report.

In your report along with Performance Rating.Rating Level.Rating Level, can you also use date from and date to check if those null records has any active date tracking. In that case, you can use date between date from and date to for eliminating those ratings levels with nulls..

If you could share the XML of your report, it would help to understand the issue better and provide resolution..

Regards

Venkat

AjayKumar Maddipati

Hi @Bhaskar Konar ,@Venkat Koduvayur-Oracle

Thanks for reply.

please find xml of above report.

XML of report rating level.txt

Regards,

Ajay

AjayKumar Maddipati

Hi Team,

MAX(Rating Level Name ) applied then sorted the issue.

Thanks,

Ajay

Venkat Koduvayur-Oracle

ok, I'm not sure whether applying max() is functionally the correct way to eliminate multiple records with duplicates.. Technically yes, it helped to remove duplicates..

It should be handled via date criteria or some other additional conditions to eliminate the multiple records for the same employee for performance rating level for a given performance document.

Nevertheless, if this works for your requirement, it should be ok.

Regards

Venkat

Bhaskar Konar

AjayKumar Maddipati,

Glad to hear that you found the information as useful and managed to resolve the issue.

Please feel free to select the best answer so that it'll help fellow community members in future.

Appreciate your time.

Cheers,