SAP Knowledge Base Article - Public

2496359 - How to create a report to find employee's Goal Count and employees with zero Goals - Adhoc reporting

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.

Environment

  • SAP SuccessFactors Workforce Analytics
  • SAP SuccessFactors Goal Management
  • Ad Hoc Reporting

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 theirselfs, 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

See Also

 2392289 - Objective Distribution Tile not working for zero goals

Keywords

goal count, goal report, objective count, objective distribution, goal 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 Core all versions ; SAP SuccessFactors Workforce Analytics all versions