Skip to Content

Count Function in BOC

Jan 20, 2017 at 08:03 AM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
John Leggio
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.

10 |10000 characters needed characters left characters exceeded