You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/11/12 18:21:00 UTC

[GitHub] [incubator-superset] dimakern opened a new issue #2110: NULL does not get shown when grouping by a column

dimakern opened a new issue #2110: NULL does not get shown when grouping by a column
URL: https://github.com/apache/incubator-superset/issues/2110
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if 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
   
   
   ### Superset version
   "version": "0.15.4"
   
   ### Expected results
   Note that by setting series limit to 0, we're able to get expected result, which includes num_candidate_type is NULL (0 on legend)
   ![screen shot 2017-02-03 at 12 06 15 pm](https://cloud.githubusercontent.com/assets/11357615/22606609/4bca705c-ea09-11e6-9ad0-83df101bd4cc.png)
   
   ### Actual results
   Actual result does not include NULL values for num_candidates_type.  Looking at the query, there is an extra join added on num_candidates_type and as a result, when num_candidates_type IS NULL, those rows get dropped.
   
   ![screen shot 2017-02-03 at 12 09 12 pm](https://cloud.githubusercontent.com/assets/11357615/22606689/9c166764-ea09-11e6-9ab1-bbadbd7f155d.png)
   
   
   ### Steps to reproduce
   1) for Group By, select a column that has NULL values
   2) count(*) for metric
   3) Select Line time series
   4) Time Column should be one that contains string dates in the format "2017-01-01"
   5) Select day as the Time Grain
   6) Select some time range
   
   @bkyryliuk FYI

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org