Skip to Content
avatar image
Former Member

Simple Count Aggregation

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.

    Add comment
    10|10000 characters needed characters exceeded