Story Report in SuccessFactors- I am trying to get count of objectives every employee has.

[PrinceThomas]

I created a data base with #Story and want to have aggregate type count for objective ID so that i can see for each employee row how many objectives they have>
Eg 

Name Department objectiveCount  totalweightage

AAAA  Marketing          4                    100%

BBBB  Sales                5                     120%

This was easy in table report but in story report query builder the aggregate type is missing count. 

[PrinceThomas]

I tried this and somehow it still doesn't work. I created table widget as a cross tab. added row dimensions and then added column dimensions i.e. objective Id and weight. This should have auto calculated columns and sum. I also trid creating cross calculation colun then selected aggregation type as Sum and dimension as weight. even this doens't show correct value. .

[Olga_Antipina]

Sorry, but it's really hard to understand why are you strugelling that long with a pretty simple report set-up. We don't have any screenshots from you, therefore it's almost impossible to validate what you are doing and give you a precise advice. Here is an example of how I would do similar report:

Create these 2 measures:

then create a table (I don't have values for weight as it's not in my Goal plan):

[PrinceThomas]

Ok Thank you for the snapshot. Ieaxtly did what you shared. except the second restricted measure (no. of Goals) using no. of business goals to just exclude nulll value. This is where story report gets complicated and this part is not explained in any training that I went through. Once again thank you for the snap shots.