Canvas Bar charts : bars not always displaued in the same order

[Ranakel (AYRAULT Annabelle)]

Hi,
I have a bar chart in a workpad canvas in which I also have a control menu to apply a filter on my workpad.
When I use this control , my values are correctly uptdated in the bar chart but the order of the bars sometimes changes whereas I would like them to be always the same (ascending alphabetical). Is there a way to force the order of the bars ?

Thanks for your help.

[lukas (Lukas Olson)]

You sure can. If you open the expression editor, try adding | sort by="x" after pointseries and before plot. Could you let me know if that works?

[Ranakel (AYRAULT Annabelle)]

Hi
It doesn't work. I have this error message : Expression failed with the message:
[plot] > Can not cast 'datatable' to any of 'pointseries'
Thanks for your help

[Ranakel (AYRAULT Annabelle)]

Il also have this error :

here is my code

Trying to type the name of the field was not helpfull too.

[Ranakel (AYRAULT Annabelle)]

I found a solution by changing my request to an esdocs rathen than esqlt and putting the sort after the query. It works fine .
Annabelle

filters
| esdocs index="bds" query="* where country='Ivory Coast'" sort="plateforme.keyword, asc"
| pointseries y="community" x="plateforme" color="plateforme" text=""

[lukas (Lukas Olson)]

Alternatively, you could have done something like

SELECT * FROM bds WHERE country = 'Ivory Coast' SORT BY plateforme.keyword ASC