sfirke opened a new issue, #31481:
URL: https://github.com/apache/superset/issues/31481

   ### Bug description
   
   When creating a bar chart with categorical x-axis, NULL values are omitted 
from the resulting chart.
   
   **Data:**
   
![image](https://github.com/user-attachments/assets/cedc1c6b-3bd0-497b-bb91-216cb20edff9)
   
   **Bar chart fails to show NULL value:**
   
![image](https://github.com/user-attachments/assets/64d83b0c-7e27-4176-a781-a3f573fcb960)
   
   **Pie chart shows the correct data:**
   
![image](https://github.com/user-attachments/assets/11a03734-4f2b-4f1f-a3b5-5886508bebd2)
   
   **Expected behavior**
   NULL should be a series in the chart, as on the pie chart. In many cases 
it's valuable to know there are NULL values in the data. Users can always 
filter them out if desired.
   
   If you wish to create the data table used here, you can run this Postgres 
statement:
   ```
   CREATE TABLE browser_stats (browser VARCHAR(50), page VARCHAR(50));
   INSERT INTO browser_stats (browser, page) 
   VALUES 
       ('Firefox', 'home'),
       ('Chrome', 'home'),
       ('Chrome', 'home'),
       ('Safari', 'about'),
       (NULL, 'about');
   ```
   
   ### Screenshots/recordings
   
   _No response_
   
   ### Superset version
   
   4.0.2
   
   ### Python version
   
   I don't know
   
   ### Node version
   
   I don't know
   
   ### Browser
   
   Firefox
   
   ### Additional context
   
   I could find no relevant issues on GitHub or reports about this on Slack, 
which surprised me.
   
   ### Checklist
   
   - [X] I have searched Superset docs and Slack and didn't find a solution to 
my problem.
   - [X] I have searched the GitHub issue tracker and didn't find a similar bug 
report.
   - [ ] I have checked Superset's logs for errors and if I found a relevant 
Python stacktrace, I included it here as text in the "additional context" 
section.


-- 
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]

Reply via email to