Groupby() and count()

Hi SangeethaBabu

In case you need an output like {{deptID:1, count:2},{deptID:2,count:1}} you need to modify your aggregation logic. You could use the below code instead:

aggregation: a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "deptID",
alias: "deptID"
isGrouping: true
),
a!queryAggregationColumn(
field: "deptID",
alias:"count",
aggregationFunction: "COUNT"

)

}
)

Let me know if this helps.

Hi SangeethaBabu

In case you need an output like {{deptID:1, count:2},{deptID:2,count:1}} you need to modify your aggregation logic. You could use the below code instead:

aggregation: a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "deptID",
alias: "deptID"
isGrouping: true
),
a!queryAggregationColumn(
field: "deptID",
alias:"count",
aggregationFunction: "COUNT"

)

}
)

Let me know if this helps.

Hi SmitaA

But i want to use this for column chart. Can you tell me how to achieve it?. When I used the above logic Im getting separte column for each request

Could you please provide more information as to what is the x-axis and y-axis column of the column chart you want to build.

Also what do you mean by each request as stated above.