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.

[jenaklein]

Any luck? I'm struggling with the same and the call I had with support led me down the wrong path. 

[Dren]

got a workaround solution at hand.. kind of hard to post details here in a small comment box without screenshot capability 😞 so perhaps email me directly and I'll try to connect w you and explain: ***REMOVED BY MODERATION***

[Dren]

perhaps email me directly and I'll try to connect w you and explain: ***REMOVED BY MODERATION***