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

Ranakel · February 20, 2019, 4:01pm

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 · February 20, 2019, 6:31pm

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 · February 21, 2019, 9:07am

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 · February 21, 2019, 11:27am

Il also have this error :

here is my code

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

Ranakel · February 21, 2019, 3:14pm

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 · February 21, 2019, 10:27pm

Alternatively, you could have done something like

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

system · March 21, 2019, 10:27pm

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