Database view Grouping issue

[Andreas_Marinopoulos]

I am creating a database view whose first column is an id (lead_id) from the database table.

The lead_id is present more than once in the table, this is intentional. I am trying to click on configure grouping, so that I can keep a unique lead_id in the database view.

In other database views I can use column aggregation.

See from another view of mine:

But this time I cannot. Is there something I am doing wrong?

[Nikita_Fedorishchev]

Hello, @Andreas_Marinopoulos.

First of all, you need to aggregate by one of the columns, only then the grouping will become available to you.
In the other tables you did it in that order, which is why it worked.

Best Regards, Nikita.