Skip to Content

Simple Count Aggregation

Mar 12, 2017 at 11:00 PM


avatar image
Former Member


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!

10 |10000 characters needed characters left characters exceeded

Hi Federico,

Did that work?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
John Leggio
Mar 14, 2017 at 10:09 PM

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.

10 |10000 characters needed characters left characters exceeded