Count of One particular aggreagte

Hi All,

I have 10 source in my aggregate , where i want to get the count of one particular source with respect to the particular row. How to Implement this? Please advice

Hi Saravanan,

Unfortunately I'm not sure what you mean. Can you give an example of what you want to achieve?

Saravanan Santhanam wrote:

Hi All,

I have 10 source in my aggregate , where i want to get the count of one particular source with respect to the particular row. How to Implement this? Please advice

Hi Saravanan,

there are some basic steps to get count in an aggregate, 

you have to do groupby with the particular attribute, that you wish to get count .

For example i have 2 sources product and status and i want the count of product status wise, So i used,

1. groupby on status label

2. count on product.

check the following picture:

 

This may help you to get your solution.

Regards

Seema