Count of Group by
Question

I have the aggregate as shown above, I need a count of the underlaying items of the groups, any one an idea?


Roelof Jan wrote:

I have the aggregate as shown above, I need a count of the underlaying items of the groups, any one an idea?


Hi Roelof,

right click on Id coumn and select count. 


Seema Pandey wrote:

Roelof Jan wrote:

I have the aggregate as shown above, I need a count of the underlaying items of the groups, any one an idea?


Hi Roelof,

right click on Id coumn and select count. 


Thats is giving me a result of 45 for every group, but that is not what I need


Roelof Jan wrote:

Seema Pandey wrote:

Roelof Jan wrote:

I have the aggregate as shown above, I need a count of the underlaying items of the groups, any one an idea?


Hi Roelof,

right click on Id coumn and select count. 


Thats is giving me a result of 45 for every group, but that is not what I need



Then probably there are 45 records in each group, because this will give exact count of records  for each row.

use your aggregate count:

 

André Pinho wrote:

use your aggregate count:

 


thats the total result of the groups, I need the amount of underlaying data records from each group. not the count of the total of groups


Can you explain your problem in more detail the terminology could be misleading,

Do you want the count within each group? try the count method Seema explain but in non grouped attribute:

The columns in grey.

I realize this thread is quite old, but I think I am having the same problem.  I have my data grouped by the element ID/Element Title.  I want to know how many rows are within each element.  I added the count column as suggested, and in the example data, it shows 6 items in each element.  When I put an expression on my view and publish it shows the count all all the rows, regardless of element, so instead of 6 items in each one, it shows a total of 72.  How can I get each line item to show just how many rows are in the group?



Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.