show count value on attribute entity

show count value on attribute entity

  

I have already make the COUNT (aggregates) in SQL, but i want to show the value of COUNT on another attribute/coulmn. Like this 

but the results are like :

so, what i have to do to show the count result on another attribute/coulmn ?

Thanks,

Fahmi

In your aggregate, click down arrow icon on the right of your selected column.

Click Count.


Then click on another Column, and click Group By

Resulting query will only include column in blue color:

Harlin Setiadarma wrote:

In your aggregate, click down arrow icon on the right of your selected column.

Click Count.


Then click on another Column, and click Group By

Resulting query will only include column in blue color:


i want to show it in SQL output, not in aggregate. Do u know ?


In SQL output, you need to create a structure containing all of your entity's columns and count column.

Make sure your structure have the same column name and order like your sql result.

Then attach this structure to your SQL output.