sfirke opened a new issue, #21425: URL: https://github.com/apache/superset/issues/21425
When a dimension + x-value combo is absent from the data, the sorting malfunctions on bar chart v1. The x-value with the null dimension combination appears shifted left. #### How to reproduce the bug Create dashboard with a check-multiple filter and a bar chart v1 (because v2 is not yet custom sortable). Specify sorting for the x-axis variable using custom SQL like: ``` CASE WHEN [Day of Week] = 'Sunday' THEN 1 WHEN [Day of Week] = 'Monday' THEN 2 ... ``` There should be no records in the data for a specific combo of the filter variable and the x-axis variable. In this case, no Fatality has occurred on Thursday in the given time range. ### Expected results When I exclude the Fatality value on the filter, the Thursday x-axis value appears in the proper spot.  ### Actual results When I include Fatality in the filter, Thursday appears following Tuesday. Note *null* in tooltip:  ### Environment Superset 2.0.0. GENERIC_CHART_AXES is active along with other flags. ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest released version of superset. - [x] I have checked the issue tracker for the same issue and I haven't found one similar. -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
