Canvas bar chart not sorting

Hello,
I am running an ESQL to visualise a bar chart.
Sort by is not working for me.
The same query on a table works as expected.
Am I missing anything? Bug? Feature?
Version 7.9.2

filters "timefilterControl"
| essql 
  query="SELECT COUNT(field.keyword) AS count, field.keyword
FROM \"my-index*\"
GROUP BY field.keyword
order BY count DESC
LIMIT 10"
| pointseries x="count" y="field.keyword"
| sort by="x" reverse=false
| plot defaultStyle={seriesStyle bars=0.75 horizontalBars=true color="red"} legend=false xaxis=true 
  font={font family="'Open Sans', Helvetica, Arial, sans-serif" size=12 align="left" color="#FFFFFF" weight="normal" underline=false italic=false}
| render


Thanks!

Hi @AClerk. Looks like there is an existing bug report for this. I suggest you copy and paste your question there to help the Canvas team prioritize this bug.

1 Like

Thank you for confirming.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.