Skip to Content
avatar image
Former Member

Count Function in BOC

I would like to know whether a count function can be implemented to find out the number of fields that have value1==”sample1”&&value2==”sample2”, the two values coming correspondingly from two different columns, or at least a count function for the values in the rows in one column. Something similar to the numbers coming from Record Summary in the Column Information before having created the model. From then on, would it be possible to build stories on top of those numbers?

I feel a little bit constrained from the need to specify such fields as Dimensions and the fact that all segmentations during the visualization is based on the measure numbers… Would you recommend me a solution approach for this case or would you say that the platform is not suitable for this kind of analysis?

Thank you for your time and consideration.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 09, 2017 at 03:52 PM

    Hi Simona,

    You can use the Account / Measure calculation editor to create a calculated account for this

    Type: Aggregation

    Operation: Count

    I would use the conditional aggregation feature to specify the dimension values that you want to include in the count.

    Add comment
    10|10000 characters needed characters exceeded