Hey.
I ran your question through ask docs in Appfarm AI. Let me know if it works!
You’re running into a known limitation of how the Basic and Advanced charts handle the Category Property when it’s set to a Datetime type with a “Week” grouping. The chart only renders categories where data actually exists, so weeks with no data are simply skipped.
Here are the two main approaches to solve this:
Option 1: Use a Calendar Data Source (recommended)
This is the most robust solution. Instead of relying on the chart to generate week categories from your data, you drive the x-axis from a Calendar Data Source that always contains all 52 weeks.
The approach works like this with an Advanced Combined Chart or Advanced Bar/Line Chart:
-
Create a Calendar Data Source with From set to today minus 1 year (using a Value Processor: Subtract 1 Year), To set to today, and Resolution set to Week. This gives you exactly 52 objects, one per week.
-
Use Static Datasets on the chart instead of the default dataset mode. Each static dataset gets its own Filter that matches your data to the calendar week (e.g., where your data’s date falls within the calendar week’s DateTime Value and Period End).
-
Set the Category Property to the Calendar Data Source’s Week Number (ISO) property.
This guarantees all 52 weeks appear on the x-axis regardless of whether data exists for them.
Option 2: Use Min Value / Max Value on the Axis
The Advanced charts (such as the Advanced Bar Chart and Advanced Line Chart) support axis configuration properties including Min Value and Max Value.
However, the negative week number issue you’re seeing is a known side effect of how the chart engine interprets the Min Value when the Axis Type is set to Category. The Min Value is treated as a numeric index into the category list, not as a week number — so setting it to, say, week 1 of last year can produce unexpected negative or zero-based values.
To avoid this, try setting the Axis Type explicitly to Category (not Auto) and leave Min/Max unset, relying instead on the Calendar Data Source approach above to control which categories appear.
Regarding the negative week numbers bug
This is most likely not a bug in the traditional sense — it is the chart engine interpreting your Min Value as a raw numeric offset rather than a week number. Since ISO week numbers can start at 1 and the chart may be calculating relative positions, values below the first data point can render as negative. The Calendar Data Source approach sidesteps this entirely because the categories are always explicitly defined.
