dosubot[bot] commented on issue #33905: URL: https://github.com/apache/superset/issues/33905#issuecomment-3004586881
<!-- Answer --> This issue is likely related to how Superset handles time ranges and time grain in the backend query. The X axis only shows periods present in the query result, so if the last month is missing from your chart, it's probably not included in the query output. This can happen if the time range end boundary is exclusive or if the SQL time grain logic doesn't generate a row for the last month. There have been recent fixes that may help: one ensures all x-axis date labels for the selected time grain are displayed ([PR 33191](https://github.com/apache/superset/pull/33191)), and another adds an option to show all X axis ticks on timeseries charts ([PR 33729](https://github.com/apache/superset/pull/33729)). Make sure your deployment includes these changes and try enabling the new X axis tick display option if it's available. If the issue persists, check the SQL generated for your chart to confirm the last month is included in the result set. Adjusting the time range or time grain settings may help. If you need the last month to appear even when there is no data, you would need to pad missing periods in your dataset or adjust the backend query to generate all expected periods, as the frontend does not do this automatically. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/3673d29a-4a33-4546-9227-cff67e9f5270?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/3673d29a-4a33-4546-9227-cff67e9f5270?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/3673d29a-4a33-4546-9227-cff67e9f5270?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/3673d29a-4a33-4546-9227-cff67e9f5270?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/3673d29a-4a33-4546-9227-cff67e9f5270?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/3673d29a-4a33-4546-9227-cff67e9f5270?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/3673d29a-4a33-4546-9227-cff67e9f5270?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [! [Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/33905) -- 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]
