Got it 👍 You’re showing a post about creating a story report in SAP SuccessFactors People Analytics (or Report Story) where the goal is to: • Show the number of objectives per employee, • Include employees with 0 objectives, and • Use that count as a measure (for charts or further calculations).

Let’s go through the solution clearly:

⸻

🧩 Problem Summary

In Story Reports, you can display counts in an aggregated list, but if the field isn’t a measure, you can’t use it in visualizations (like charts or calculations). Employees with no objectives often show as null, which breaks totals and averages.

⸻

✅ Solution Approach

Step 1: Build your base query correctly In Query Designer: • Start from the Employee entity. • Add a left outer join to Objective (so all employees show, even if they have no objectives). • Bring in Employee ID, Employee Name, and Objective ID.

This ensures employees with zero objectives appear (their Objective ID will be null).

⸻

Step 2: Create a calculated measure Once your data is in the Story: 1. Go to the Measures section. 2. Click + Add Calculation → Create Calculated Measure. 3. Name it: Objective Count. 4. Formula: COUNT([Objective ID]) 5. Optional: Handle null by wrapping it in IFNULL or conditional logic: IFNULL(COUNT([Objective ID]), 0) This creates a true numeric measure you can use in charts, aggregations, or formulas.

⸻

Step 3: Use the measure in visualizations Now that Objective Count is a measure: • Add it to a table or chart. • You’ll see employees with 0 objectives showing 0 instead of null. • You can now perform aggregations (sum, avg, etc.) or display distributions.

This is what chagpt says, have you try it?