Hi, we use kibana canvas line chart element with 2 values comes from our custom indexes anybody knows how to sort y axis desc or asc it adds new values to top
there is my expression
filters
| essql
query="SELECT * FROM "dwhtest-logs-*" WHERE DS1_queue IS NOT NULL Order By "@timestamp" DESC Limit 50"
| pointseries y="DS1_queue" x="@timestamp"
| plot defaultStyle={seriesStyle lines=3 color="#ca5f35"} yaxis=true
| render