Simple Count Aggregation

[former_member55563]

Hi,

We are creating a very simple demographic story in BOC to test the capabilities. File input contains only Employee Number, male/female, Salary and many other stuffs.

Looks like EE number is by default SUM and hence if we want to create a simple chart pie chart with the % of female versus male it doesnt work as expected. How a simple aggregation can be defined for that basic model? Thank you!

[JohnL]

Hi Federico,

Did that work?

[JohnL · Accepted solution]

Hi Federico,

Is male/female a dimension or an attribute of your employee dimension?

If its a dimension, then you can create an aggregation calculation (with operation of COUNT) in the story.

See the attached screenshots.