Time-Series Gap Filling in Superset: Apply Resampling to the Entire Target Period

[inctl]

Apply Resampling to the Entire Target Period

Superset version: 4.1.2 and 6.1.0

Requirement:

I need to be able to view an area or bar chart in which missing data points are set to 0.
I have set a time granularity and enabled “Resample to zero” for the time axis.
However, the resampling only applies between two data points.

Case

If I have only one data point per day, I end up with a bar that spans the entire day.
I want all hourly data points to be set to 0.
Since version 6.1.0, I’ve noticed that by setting a JSON echart with this value, the result is correct.
But I can’t make the start and end values dynamic.

{
  "xAxis": {
    "min": "2026-07-01 00:00:00",
    "max": "2026-07-02 00:00:00"
  }
}

Conclusion

It would be helpful if this were handled by default with the resample.
And if possible, to have an auto-resample aligned with the time granularity, allowing the time granularity filter to be used in a dashboard.

Thank you advance,

[inctl]

One solution you could suggest is to include Jinja templating in the ECharts JSON configuration.
We could then set the start and end dates there.
But it's still best to have the start and end dates set correctly from the beginning.