[ES|QL] Group by a function and reusing the column in another pipe is rendered as error while it is valid

[drewdaemon]

No description provided.

[drewdaemon]

@stratoula @dej611 can one of you help me with a more-specific reproduction?

I tried the following but it all works fine...

from kibana_sample_data_logs
| stats average = avg(bytes) by agent.keyword
| sort average

[stratoula]

Hey! why did you create a new issue? I am tracking everything here #177699 so I am closing it in favor of the other. I was thinking of just referencing the main issue on the PRs (Part of ...). I am going to keep it open until 8.14 FF , I want to gather everything there for better visibility and I don't think we need extra issues for every case.

In your example you are not referencing the group by. Try something like this

from kibana_sample_data_logs
| stats average = avg(bytes) by abs(bytes)
| sort `abs(bytes)`

or the one I have on the main issue (in the gif)

[drewdaemon]

why did you create a new issue?

I was trying out the pattern of having individual issues associated with each checklist item.

I was thinking of just referencing the main issue on the PRs

Sounds good to me! 👍