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!