SAP Knowledge Base Article - Public

2496359 - How to create a report to find employee's Goal Count and employees with zero Goals, using Ad Hoc / Table reports?

Symptom

How to create a Goal Management Ad Hoc report to find employee's Goal Count per goal plan by using the Aggregate Function?
How to create a Goal Management Ad Hoc report to find employees with zero Goals?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
  • SAP SuccessFactors Goal Management
  • SAP Analytics Cloud

Resolution

  1. Navigate to Ad Hoc Reporting > Create a New Report and select Goal Management.

goal count report 1.JPG

  1. Enter the Report Name in General Info.
  2. In the People tab, define the Report Scope.
  3. In the Datasets tab, select the required Goal Template.
  4. In the Columns tab, select the following columns: Goal Plan Name, Goal Owner First Name, Goal Owner Last Name, Goal ID. Note: You can select other columns such as Goal Owner Info columns, however when you select any other goal columns, goal count will be counted per row based on the other goal field you selected.

 goal count report 2.JPG

  1. Still in the Columns tab, under Summary of Actions, click on Group By then click on Add another aggregate column. Select Goal ID as the Aggregate Column and COUNT for the Function.

goal count report 3.JPG

  1. You can also limit the results by adding filters in the Filters tab. For instance, only include Active goals in the report.

goal count report 4.JPG

  1. Save and Generate Report.

P.S.:  Make sure to remove any date columns based on timestamp from your report. Timestamp based columns will always differs from themselves, which will cause the report to generate many rows of records.

How to report for employees with zero Goals:

If you want to show employees with zero Goals only, you still need to follow steps 1 - 6 above, then please add under Filter Tab, Goal ID Is null. Save and Generate Report.

This will pull employees Goal count then will filter Goal IDs with zero goals.

goal count zero.jpg

Keywords

goal, objective, count, report, distribution, management, ad, hoc, report, zero, goals , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-GM-REP , Reporting and Data Imports Exports , How To

Product

SAP SuccessFactors HCM all versions