Hi Community,
I want to perform count() operation on a column. And also remove duplicates in query aggregation. But i can't able to use both at same time. Im getting duplicates for subject id.
{101,1},
{102,1},
{103,2}
here i want the count of deptId as 2 but im getting count as 3
aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "EmployeeID", isGrouping: true ), a!queryAggregationColumn( field: "deptID", aggregationFunction: "COUNT"
)
} ),
Discussion posts and replies are publicly visible