Skip to Content
author's profile photo Former Member
Former Member

Pulling distinct values from an Object and then counting instances.

Hello, I'm very new to BO and no one in my business knows how to use BO very well so this might be basics or it might be hard, I'm still too new to know which. I'm basically learning by hammering buttons until I get what I want.

I have a query that gives me a set of data (great) and lets say one column looks like the following

[Fruit]

Apple

Apple

Pear

Grape

Apple

Pear

Apple

How do I get BO to extract all the distinct values and then count how many of each exist in the object? In other words I would like an output of

|Apple | 4|

|Pear | 2|

|Grape | 1|

If it was just excel then I would just use countif's but I cannot work out if I can even do this in BO. Sorry for the incorrect terminology I might be using and thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 13, 2016 at 05:18 PM

    Hi,

    First drag Fruit object in the table.In the second column paste below formula.

    =Count([Fruit];All)

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.