Time series of month is not continuous in the line/bar charts

[bsenthilbalu]

I tried all these, but still I don't get the month names continuously in my charts. The X-axis labels skips few months in between by 2 or 3. Any fix for this issue ?

You can put %b in x-axis to order by month name

Originally posted by @RenanLeiteBay in #29237

[dosubot]

Hey @bsenthilbalu! 👋 I'm here to help you with your coding conundrums!

To ensure continuous display of month names on the x-axis in Apache Superset, you might want to check the minInterval property, which determines the intervals for x-axis labels in time series charts. This property is influenced by the xAxisType and timeGrainSqla. If the xAxisType is set to AxisType.Time and timeGrainSqla is defined, the minInterval is mapped to a timestamp value. If these conditions are not met, the minInterval defaults to 0, which might cause skipping of months ^[1].

Additionally, ensure that your time grain settings are correctly configured to reflect monthly intervals. If the issue persists, it might be related to known issues such as time range filters not being applied correctly or time grain not being set when using Jinja in datasets ^[2].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[bsenthilbalu]

Hey @bsenthilbalu! 👋 I'm here to help you with your coding conundrums!

To ensure continuous display of month names on the x-axis in Apache Superset, you might want to check the minInterval property, which determines the intervals for x-axis labels in time series charts. This property is influenced by the xAxisType and timeGrainSqla. If the xAxisType is set to AxisType.Time and timeGrainSqla is defined, the minInterval is mapped to a timestamp value. If these conditions are not met, the minInterval defaults to 0, which might cause skipping of months [1].

Additionally, ensure that your time grain settings are correctly configured to reflect monthly intervals. If the issue persists, it might be related to known issues such as time range filters not being applied correctly or time grain not being set when using Jinja in datasets [2].

To continue talking to Dosu, mention @dosu.

Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other

Where I can see that mininterval property in the Superset chart properties ?

[hainenber]

Can you add screenshot of line/bar charts affected by the issue? The image in description came from old post so I don't know what to debug.

Kindly anonymize any PII data if necessary.

[bsenthilbalu]

Please see below

[rusackas]

It seems like it just skips some because the labels are too long to fit on all the X axis ticks. What would be your proposed solution?