Oracle Analytics and AI

Tyler Buczynski

I've written a report in order to provide aggregate data for our performance documents and their rating score. My report produces the correct data, with the exception of it producing an additional line of data for each employee. The only difference in the two lines is the calculated manager overall rating field. On one line it shows the rating score, and on the second line the field is blank. How should I remove the additional line with the blank information in the calculated manager overall rating field. Screenshot below for reference:

Shankar-Oracle

Please try the following:

1. Save your analysis with a different name (so that you do not overwrite your existing analysis as a precaution)
2. Click on the advanced tab of the respective analysis
3. Under Advanced SQL Clauses section, you would see a check box for "Distinct"
4. Check that check box and click on results

If all goes well, save your analysis (created as part of step 1) as needed.