bryanck opened a new issue #12622: URL: https://github.com/apache/superset/issues/12622
The bar chart no longer sorts query results in descending order. If you apply a row limit to the chart, then an arbitrary set of rows will be returned (depending on the DB). ### Expected results For the bar chart by default to generate a query that sorts results in descending order, so the top N rows, based on the metric, will be selected when applying a limit. AFAIK this was the previous behavior. ### Actual results If a limit is applied, then an arbitrary set of rows is returned, not the top N rows based on the metric. #### Screenshots #### How to reproduce the bug 1. Create a bar chart 2. Limit the results to a number less than the total number of rows 3. The bar chart will display arbitrary results rather than the top results based on the metric ### Environment - superset version: 1.0 RC4 - python version: 3.7.9 - node.js version: 12.14.1 ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [*] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [*] I have reproduced the issue with at least the latest released version of superset. - [*] I have checked the issue tracker for the same issue and I haven't found one similar. ### Additional context I can work around this issue by forcing `order_desc` to `true` in `viz.py`. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
