[Canvas] Stacked bar rendering fails in some cases

[wylieconlon]

Example expression:

filters
| essql 
  query="SELECT \"geo.src\", \"geo.dest\", COUNT(*) as c FROM \"kibana_sample_data_logs\" WHERE \"@timestamp\" > NOW() - INTERVAL 7 DAYS GROUP BY \"geo.src\", \"geo.dest\" ORDER BY COUNT(*) DESC LIMIT 50"
| pointseries x="geo.src" y="c" color="geo.dest" text="geo.dest"
| plot defaultStyle={seriesStyle bars=0.8 stack=true}
| render

Example output as bars:

I suspect that this is caused by some kind of issue with sorting.

[elasticmachine]

Pinging @elastic/kibana-canvas (Team:Canvas)

[wylieconlon]

Comparing this to the vega editor with the same dataset:

Try it in the vega editor

[ThomThomson]

Closing this as we are not prioritizing Canvas chart visuals for the time being. A workpad author can use a chart from Lens instead for more appropriate styling.