propellerjet opened a new issue, #41156:
URL: https://github.com/apache/superset/issues/41156
### Bug description
In a Mixed Chart configured with Stacked Bars for both metrics, missing data
points (NULLs) for specific categories in a given time period are incorrectly
rendered.
Displays these missing values as 0 and 1 on the bars and erroneously reports
them as 1 in the tooltip.
Steps to Reproduce:
1. Create a new Mixed Chart.
2. Configure the following settings:
X-Axis: Time column (e.g., Year).
Series/Group By: Categorical column (e.g., Quarter).
Metrics: Add two metrics (e.g., Query A and Query B).
Chart Type: Ensure both metrics are set to display as Bar and enable
Stacked Bars.
Tooltip: Rich type enable
3. Prepare data with the following scenario:
Year 1: Data exists for all Quarters (Q1, Q2, Q3, Q4) for both metrics.
Year 2: Data exists only for Q1 and Q2. Q3 and Q4 are completely missing (no
rows in the dataset) for both metrics.
Run the chart.
Hover over the bars for Year 2
### Screenshots/recordings
Query A
<img width="1780" height="862" alt="Image"
src="https://github.com/user-attachments/assets/3b53c705-88af-4515-a25c-9af152f2de28";
/>
Query B
<img width="1780" height="279" alt="Image"
src="https://github.com/user-attachments/assets/261f87ec-8ed8-437f-8aa3-4b4de842f81c";
/>
Tooltip
<img width="550" height="240" alt="Image"
src="https://github.com/user-attachments/assets/9651cc98-c496-4ee6-8b39-f60ae51ee189";
/>
### Superset version
6.0.0
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### 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]
