sortby dose not work?

[wendy2017]

[zhaoyongjie]

@wendy2017 Could you provide more detail for this case? for example, 1) what do you expect to sort? 2) the SQL for the chart.

[sfirke]

What version of Superset are you running? I find bar chart v2 sorting to be incomplete in 2.0.1, but there is a PR merged into main branch that looks like it should fix that (#21993) if you try the latest version.

[wendy2017]

for bar:
Use sortby to select a metric in the y-axis. It is expected that the y-axis can be arranged in a certain order, but it does not take effect in practice；
but Use x-axis sort by to take effect

[wendy2017]

i have another question:
for interface(api/v1/chart/data?form_data=xxx),what's purpose of post-processing：{is_sort_index：number}

[wendy2017]

Why sortby can't implement the function of xaxis sortby？i want to know the reason

[zhaoyongjie]

for bar: Use sortby to select a metric in the y-axis. It is expected that the y-axis can be arranged in a certain order, but it does not take effect in practice； but Use x-axis sort by to take effect

Hi @wendy2017
I can't reproduce the issue. I make a screen recording for the axis sort with the y-axis and x-axis.

sort.by.y.axis.mov

[wendy2017]

Can I use sortby instead of X-Axis sortby to realize the functions in video? Or can you showthe use of sortby

[zhaoyongjie]

Can I use sortby instead of X-Axis sortby to realize the functions in video? Or can you showthe use of sortby

the Sort By control affects Order By clause in the SQL while the X-Axis Sort By controls the order of the results in the query result.

[wendy2017]

I don't understand
Use Sortby, but there is no change in eccharts
Is there any example that can demonstrate the sortby controls

[zhaoyongjie]

the Sort By control affects SQL instead of charts.

I don't understand Use Sortby, but there is no change in eccharts Is there any example that can demonstrate the sortby controls

[wendy2017]

According to what your image，Will your data be sorted by AVG（”Sales")？

[wendy2017]

i tried to do like your image,but my data is not sorted by AVG(TOTAL_CNT)

[zhaoyongjie]

i tried to do like your image,but my data is not sorted by AVG(TOTAL_CNT)

try to add AVG(TOTAL_CNT) into x-axis sort by control because the data in results panel was pivot table rather than raw table.

[Cmagno13]

Sorting on the 2v bar graph is not working. Any suggestions for correction.

[sfirke]

A couple of PRs related to bar chart sorting were recently merged onto master branch, it would be good if someone could see if this behavior continues with latest.

[yousoph]

Can't repro this on the latest master - if this is still happening please reopen or create a new issue with detailed repro steps. Thanks!