JohnDietrich-Pepper commented on issue #27245: URL: https://github.com/apache/superset/issues/27245#issuecomment-1986750165
> @JohnDietrich-Pepper I see the issue.. When implementing this fix in #26429 , we didn't consider the case where values are expected to terminate early, only how to deal with interim values. > > I wonder if there's some middle ground here? For instance, automatically interpolating zeros until the last defined value, and then leaving the rest null? This would ensure continuous series, but also make sure they terminate when expected. While I understand the problem described in this issue, the problem described in #21093 is IMO also quite problematic, and likely more common than this one.. That would probably work but I dispute the notion that #21093 is problematic. The issue in #21093 can be solved in the query with a IFNULL and the solution is disingenuous to the end user because it implies data is in a particular X value when the reality is no data is present. Consider a case of a sensor (for a car, weather, etc...) there is a big difference between the sensor returned no data and the sensor returned a zero value. The solution takes the position that 0 and null are the same. Real world example. In my day job one of the data sets my data engineering team works with is sensor data that comes off commercial airline flights looking for anomalies in mechanical parts. If we had implemented Superset we would have been in a world of hurt with this change because we need to track the cumulative sum of defects and also periods when the sensor is offline. The original view is correct and what we have implemented in our reporting platform (Tableau) -- 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]
