Error Position

Hi, Guys! im a new here. I got the error like this

> ERROR: column "ph.company_size" must appear in the GROUP BY clause or be used in an aggregate function Position: 2919

actually, how to read the position, where to find 2919?
Thanks, appreciate your help

Hi @alk0301

That's currently not possible to easily locate that, but make sure that whichever columns you have in your select-clause should also be in your group-clause.

You can try running your query directly on your database and see if it helps you locate the problem.

There's a request for such functionality, which is a lot harder than what people think.
https://github.com/metabase/metabase/issues/625 - upvote by clicking :+1: on the first post