Story Report for Goal Management - how many employees have set goals, who doesnt have any

[Dren]

Hi - I'm struggling to create a "simple" Story Report that would allow to drill down on a pie chart or bar chart that shows A amount of employees that have 0 goals set for 2025 goal plan, and B that have goals.

If I click on the B, it would list who are those individuals and their respective goals

If I click on A, it whold show the list of the idividuals with all job info details etc etc so and management hierarchy

Hopefully somebody has already solved this. Appreciate the knowledge-sharing and support!
Dren

[Olga_Antipina]

you need:

1. to create a calculated column in Query to differentiate employees with and without goals.

2. in the Designer mode create a chart where you add a measure "Headcount" and as a dimension your calculated column "With/without goals".

3. Then you should create a table and link it with a chart to be able to drill down.

[AlexanderP87]

Emp with one Goal

IF(ISNULL([Goal Management#Primary Goal Fields#Goal ID]) ,0 ,1 )

GOAL Status

IF(ISNULL([Goal Management#Primary Goal Fields#Goal ID]), 0, 1 )