YiouZuo commented on issue #19507: URL: https://github.com/apache/superset/issues/19507#issuecomment-1211567090
I have a similar issue -- Timeseries Bar Chart V2 malfunctions when there is NULL in the results, though in my case, not directly from the data. I'm counting each group's occurrence each month. However, some accounts may not appear in all months, creating NULL in the query results. The original data doesn't have NULL. Sample data : Date, Group, Occurrence 2020-01-01, a, 2 2020-01-01, a, 3 2020-02-01, a, 5 ... 2020-06-01, a, 5 2020-06-01, b, 1 2020-06-01, b, 2 2020-06-01, b, 1 ... 2020-06-01, c, 4 2020-06-01, c, 1 ... 2021-12-01, a, 5 2021-12-01, c, 5 ... Screenshots show the query results: for group b, when it had no occurrence from 2021-11 to 2022-3, it's NULL, and the corresponding stacked bars on the chart are not correctly displayed (missing group c for 3 out of 5 months).  The test data I created (repeat 5 times for the full set): [test_null_timeseries_v2.csv](https://github.com/apache/superset/files/9306295/test_null_timeseries_v2.csv) -- 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]
