Reporting on job codes and employee count excludes job codes without assigned employees

[Thomas_Barrett]

Hello,

I am trying to create a story report that shows all the job codes for our organization and how many individuals are in the job code. I am able to create a report that shows all the job codes, however, when I include an employee count, any job code that currently has 0 employees assigned to it disappears from the list. I am able to get accurate counts of individuals by job code where people are assigned but I also need to see all the job codes that don't have anyone assigned in the same list. I've tried to adjust the settings for items like unbooked members and show 0 in table are selected but I haven't found a setting that works. I have had a similar situation arise when reporting on job requisitions without applications. 

Has anyone else experienced this and if so, did you find a workaround? 

[subbareddyven]

Hi @Thomas_Barrett ,

This can be achieved through Blending

Suppose if you want to display all Business units in a instance and corresponding count of users assigned to this Business units.

Create a new Data Source (say BU) select Business unit name field from Foundation Object Business unit

Create one more Data source (say JI) on Job information object select fields like Business unit and user id field from this

Later in Story designer Link these two data sources by Business unit field which is common between them

Select a chart widget through Add linked model add both the data sources in the chart widget

Under Dimensions select Business unit field from Data source BU and select Unbooked members

Under measures Select Count from data Source JI

In the output chart widget you see all the Business units even the one that are not associated with a user and their count.

Regards,

Subbu