[GitHub] [superset] YiouZuo commented on issue #19507: [Timeseries Bar Chart V2] Bars disappear when changing the contribution mode to "Total"

[GitBox <gi...@apache.org>]

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).
   ![Screen Shot 2022-08-10 at 10 15 08 PM](https://user-images.githubusercontent.com/15369109/184069932-0e8613e6-0b0e-4ace-84f6-1df9ac93a084.png)
   
   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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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