Samuelinto commented on issue #23847: URL: https://github.com/apache/superset/issues/23847#issuecomment-3400284553
Hi @sfirke thanks for your response. We were able to look deeper into the code base and found out that the issue persists within different types of databases and different time grains. As you alluded above, what appears to be happening is that the SQL query uses the truncated values provided by the time grain to filter the entries, which is causing only the rows that have the time set to exactly the first day of the month at midnight to be shown. The solution we came up with was adding a different conditional filter for datetime columns that uses the granularity to set an upper and lower bound to the queries. We're currently working on implementing the fix, but we wanted to get your opinion on if this seems like a correct approach. We also noticed that different charts build the drill-to-detail filter payloads in different ways that don't seem to suffer from this issue. Do you know if there is a reason for this difference? Thank you. TableChart.tsx payload builder: <img width="623" height="269" alt="Image" src="https://github.com/user-attachments/assets/3aa67bd7-60cf-4745-aec7-cc71405e1102"; /> EchartsMixedTimeseries.tsx payload builder: <img width="429" height="286" alt="Image" src="https://github.com/user-attachments/assets/01892cbd-3123-493d-beb9-0e56b4f8c07b"; /> -- 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]
