Missing combination in data leads to odd sorting on Bar Chart v1

[sfirke]

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!

• 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.

[Shazad-khan]

In the latest version of Superset this issue has been fixed please recheck it and close if fixed.

[sfirke]

Unfortunately that seems not to be the case. I just reproduced this bug on latest as of 5 minutes ago and I'm seeing the same error:

My workaround was to create a view of the data that populated zeroes into groups with no data.

[Shazad-khan]

can you make a small video of how you are trying to reproduce it for more clarification so that i can resolve this issue.

[rusackas]

@sfirke is this still a problem?

[sfirke]

I just replicated it in 3.1.1 😦