[chart]Time Series Bar Chart does not sort

[lctdulac]

Hi SuperSet community,
I encountered a bug where my Time Series Bar Chart is not sorting correctly.

Expected results

Sort in this order : Trusted > Neutral > Low > Medium > High

Actual results

Sorted like : Low > Medium > High > Trusted > Neutral

Environment

Superset Version: 1.0.1

Additional context

Other charts seem to be sorted correctly with same logic (Table chart) :

Thanks for your hard work.

[junlincc]

same as #13807

[john-bodley]

Related to #9998.

[rusackas]

@zhaoyongjie any advice on how to move this forward?

[zhaoyongjie]

@zhaoyongjie any advice on how to move this forward?

let me dive in this issue.

[fdzuJ]

On 2.1.0 in time-series bar chart dimensions are still sorted alphabetically (irrespective of sort by clause)

[zhaoyongjie]

the time-series bar chart is a legacy chart, please check the echart version for sorting.

…

On Tue, May 2, 2023 at 2:11 PM fdzuJ ***@***.***> wrote: On 2.1.0 in time-series bar chart dimensions are still sorted alphabetically (irrespective of sort by clause) — Reply to this email directly, view it on GitHub <#13792 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAPMKUWC2R2JL5KGJAYTITDXED2V3ANCNFSM4ZZDM6SA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Best regards, Yongjie

[fdzuJ]

the time-series bar chart is a legacy chart, please check the echart version for sorting.

There are two time-series bar charts - one marked as legacy, the other is not. I'm using the one which is not marked. Also it has "ECharts" tag.

[zhaoyongjie]

Okay, makes sense, could you explain what is "dimensions are still sorted alphabetically" and what you want?

…

On Tue, May 2, 2023 at 2:25 PM fdzuJ ***@***.***> wrote: the time-series bar chart is a legacy chart, please check the echart version for sorting. There are two time-series bar charts - one marked as legacy, the other is not. I'm using the one which is not marked. Also it has "ECharts" tag [image: bar charts] <https://user-images.githubusercontent.com/57793097/235665124-f974f254-c8e3-4cf3-a020-580da8e9f1c7.png> [image: echart] <https://user-images.githubusercontent.com/57793097/235665351-d63b208c-5012-4031-a9ff-629b08be44ae.png> — Reply to this email directly, view it on GitHub <#13792 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAPMKUS4DDV7EZWBBBTLTHDXED4MLANCNFSM4ZZDM6SA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Best regards, Yongjie

[fdzuJ]

Okay, makes sense, could you explain what is "dimensions are still sorted alphabetically" and what you want?

Exactly the same as original issue.
I've got metric in 4 categories (in example they are 17, 18, 19 and 20). But in stacked bar chart I want them to appear in order 19, 20, 17, 18.
Here is "SORT BY" clause I use:

And here is resulting chart still sorted alphabetically:

[zhaoyongjie]

You should open "generic axis x" feature and set how to sort metric or dimension.

…

On Tue, May 2, 2023 at 2:57 PM fdzuJ ***@***.***> wrote: Okay, makes sense, could you explain what is "dimensions are still sorted alphabetically" and what you want? Exactly the same as original issue. I've got metric in 4 categories (in example they are 17, 18, 19 and 20). But in stacked bar chart I want them to appear in order 19, 20, 17, 18. Here is "SORT BY" clause I use: [image: sort by] <https://user-images.githubusercontent.com/57793097/235671911-bc4fbcb9-dece-470a-b166-0204bc1d2f2b.png> And here is resulting chart still sorted alphabetically: [image: изображение] <https://user-images.githubusercontent.com/57793097/235672364-d07bf38f-321a-4be9-a5fd-c1029bba3de5.png> — Reply to this email directly, view it on GitHub <#13792 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAPMKUTRMQZHRQLEA3KGTF3XEEACDANCNFSM4ZZDM6SA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Best regards, Yongjie

[fdzuJ]

I enabled GENERIC_CHART_AXES feature flag which changed chart names and how I pick x axis, but didn't change ordering with same "SORT BY" - where else should I set how to sort metric or dimension? I can't find any other relative option.