andrewscarani opened a new issue #15566: URL: https://github.com/apache/superset/issues/15566
A clear and concise description of what the bug is. ### Expected results Total counts of stacked bar chart should be the same before/after `GROUP BY` has been introduced. ### Actual results Total counts of stacked bar chart with `GROUP BY` applied are **wonky** and don't match those without `GROUP BY` applied. It seems likely that this only occurs when using a `GROUP BY` on a column where the column's value could be `NULL`. ### Steps to recreate: 1. Query: ``` SELECT 'group1' as test, 10 AS count, CURRENT_DATE() AS date UNION ALL SELECT NULL as test, 5 AS count, CURRENT_DATE() AS date UNION ALL SELECT 'group3' as test, 5 AS count, CURRENT_DATE() AS date UNION ALL SELECT 'group4' as test, 5 AS count, CURRENT_DATE() AS date ``` 2. Create Time Series Stacked Bar Chart (ECharts) without GROUP BY  3. Compare with GROUP BY and observe some other weird behavior here where the two stacked colors exclude the 3rd non-null group...  #### Other Screenshots Without: <img width="1034" alt="Screen Shot 2021-07-06 at 4 57 15 PM" src="https://user-images.githubusercontent.com/4078980/124680415-3830d480-de7b-11eb-8e06-66d6b7d4a835.png";> With `GROUP BY`: <img width="1025" alt="Screen Shot 2021-07-06 at 4 47 25 PM" src="https://user-images.githubusercontent.com/4078980/124679731-d9b72680-de79-11eb-82b0-a80a291b3bcd.png";> ### Environment Not sure. Using Preset.io latest ### 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. - [] I have checked the issue tracker for the same issue and I haven't found one similar. - Maybe this one is similar? https://github.com/apache/superset/issues/13850 -- 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]
![https://user-images.githubusercontent.com/4078980/124680415-3830d480-de7b-11eb-8e06-66d6b7d4a835.png"](https://user-images.githubusercontent.com/4078980/124680415-3830d480-de7b-11eb-8e06-66d6b7d4a835.png"){kind=link}
![https://user-images.githubusercontent.com/4078980/124679731-d9b72680-de79-11eb-82b0-a80a291b3bcd.png"](https://user-images.githubusercontent.com/4078980/124679731-d9b72680-de79-11eb-82b0-a80a291b3bcd.png"){kind=link}