Can't show distinct value in canvas

[fay]

Group by query with select case when gives error: Connot use non-grouped column (Canvas elasticsearch sql)

Hello everyone I face a problem with a certain group by elasticsearch sql query when i try to use a field in select case condition but not group by it because it doubles my rows and leaves null values, i get the following error: [image]

my issue looks like this issue