You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "aaronbannin (via GitHub)" <gi...@apache.org> on 2023/05/01 20:23:36 UTC

[GitHub] [superset] aaronbannin opened a new issue, #5888: Display Null values as 0 on Timeseries Charts

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

   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [x ] 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 does not represent null values as 0 on timeseries charts.
   Related to: https://github.com/apache/incubator-superset/issues/5427
   
   For the dataset:
   Date: Value
   Jan 1: 10
   Jan 3: 7
   
   
   ### Superset version
   026.3
   
   ### Expected results
   For the above data set, Superset should draw 3 points on the chart:
   Jan 1 = 10
   Jan 2 = 0
   Jan 3 = 7
   
   ### Actual results
   The Timeseries - Line Chart and Timeseries - Bar Chart will not graph "missing" records from the query. 
   
   Line Chart: 
   - If the date range begins at Jan 1, it will draw and then connect the points for Jan 1 and Jan 3, making the relationship between the two dates look linear.
   - If the date range begins before Jan 1, the first value on the x-axis will be Jan 1, ignoring previous dates.
   
   Bar Chart:
   - Behaves similarly to the line chart, except "null" values will have no bar.
   - The only bars drawn will be for Jan 1 and Jan 3 and presented directly next to each other.
   
   - This is visually deceptive, as it inaccurately displays relationships between timeseries values.
   
   ### Steps to reproduce
   See above examples
   
   


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

[GitHub] [superset] VincentZ112 commented on issue #5888: Display Null values as 0 on Timeseries Charts

Posted by GitBox <gi...@apache.org>.
VincentZ112 commented on issue #5888:
URL: https://github.com/apache/superset/issues/5888#issuecomment-1110089068

   Has this been worked on since?


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

Re: [I] Display Null values as 0 on Timeseries Charts [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #5888: Display Null values as 0 on Timeseries Charts
URL: https://github.com/apache/superset/issues/5888


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

[GitHub] [superset] imfht commented on issue #5888: Display Null values as 0 on Timeseries Charts

Posted by "imfht (via GitHub)" <gi...@apache.org>.
imfht commented on issue #5888:
URL: https://github.com/apache/superset/issues/5888#issuecomment-1519523794

   want this feature.


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

[GitHub] [superset] tikikun commented on issue #5888: Display Null values as 0 on Timeseries Charts

Posted by "tikikun (via GitHub)" <gi...@apache.org>.
tikikun commented on issue #5888:
URL: https://github.com/apache/superset/issues/5888#issuecomment-1486117381

   this is not done... don't close bad bot
   


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

Re: [I] Display Null values as 0 on Timeseries Charts [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #5888:
URL: https://github.com/apache/superset/issues/5888#issuecomment-1791654078

   You can go to the Advanced Analytics feature in the Timeseries charts and pick the Zero Imputation fill method to mark nulls as 0s. 
   
   <img width="453" alt="Pasted_Image_11_2_23__4_30_PM" src="https://github.com/apache/superset/assets/812905/4295bea5-3d7d-43d9-b26b-5022d0b1954e">
   
   Assuming this feature resolves the need raised by this issue, I'll go ahead and close it. If the above feature doesn't serve this purpose, we can open a new issue, or potentially re-open this one.


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

Re: [I] Display Null values as 0 on Timeseries Charts [superset]

Posted by "M-Salti (via GitHub)" <gi...@apache.org>.
M-Salti commented on issue #5888:
URL: https://github.com/apache/superset/issues/5888#issuecomment-1827563742

   > You can go to the Advanced Analytics feature in the Timeseries charts and pick the Zero Imputation fill method to mark nulls as 0s.
   > 
   > <img alt="Pasted_Image_11_2_23__4_30_PM" width="453" src="https://private-user-images.githubusercontent.com/812905/280144343-4295bea5-3d7d-43d9-b26b-5022d0b1954e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTEiLCJleHAiOjE3MDEwNzgyNzIsIm5iZiI6MTcwMTA3Nzk3MiwicGF0aCI6Ii84MTI5MDUvMjgwMTQ0MzQzLTQyOTViZWE1LTNkN2QtNDNkOS1iMjZiLTUwMjJkMGIxOTU0ZS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBSVdOSllBWDRDU1ZFSDUzQSUyRjIwMjMxMTI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDIzMTEyN1QwOTM5MzJaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT04NTIzYzI5Y2VhYmQ0NDg2ZTIzMGQ4YTM2ZGM4Y2YwYzY0NGM3MDdkMmE4MWIyMWIxNDNiNDI5Njk5OTUwZWI0JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.-JAVZTiAhtqWiCS4etXmLFYpp3faA9cpOzbeuhOTz40">
   > Assuming this feature resolves the need raised by this issue, I'll go ahead and close it. If the above feature doesn't serve this purpose, we can open a new issue, or potentially re-open this one.
   
   This does work, but you have to set the resampling rule to have a frequency equal to that of the time series being visualized.


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