Notion for eCommerce operations: build a product, supplier, and costing dashboard
Build a scalable Notion eCommerce dashboard: connect Products and Suppliers, add rollups for landed cost and margin, and avoid data duplication.
Notion chart week grouping bug: fix weekly averages with a “true” formula workaround
Notion chart week grouping bug workaround: if weekly averages look wrong, group by a formula that always returns true to keep a weekly view and correct math.
TABLE OF CONTENTS
If your Notion chart shows averages that are clearly wrong only when you group by week — a common Notion chart week grouping bug — you can usually bypass the issue by grouping the chart by a simple formula property that always returns
true, while keeping the X-axis grouped by week.The symptom (what breaks)
When you group a Notion chart by week, the aggregation can behave incorrectly (even if it works with day or month grouping). This can show out-of-range values and make the chart unusable for weekly reporting.
Common signs:
- Your metric has a known range (like 1–7), but weekly values exceed it.
- Switching grouping from Week → Day or Week → Month “fixes” the math.
- Different aggregations (avg, max, min) still look wrong when grouped by week.
Step-by-step: fix the Notion chart week grouping bug
This workaround uses a stable grouping field to avoid the buggy week grouping behavior, while still letting you display a week-based chart.
1) Add a formula property that always returns true
In the database behind the chart, create a new Formula property.
Name ideas:
Chart workaround
Week bug bypass
Formula:
true
This creates a field that is the same on every row.
2) Update your chart grouping
Open your chart settings and set:
- Group by: your new formula property (the one that returns
true)
- Keep the chart’s time axis / time bucketing set to Week (if you are using a date on the axis) so the visual stays weekly
What you are doing here is forcing Notion to build the chart groups from a non-date grouping field, which avoids the broken weekly grouping behavior.
3) Validate the fix
Do a quick sanity check:
- Compare the weekly average to a manual spot-check for 1–2 weeks.
- Temporarily group by Day and see if the week’s daily values align with the new weekly trend.
Why this works (and when it does not)
Notion Charts are still evolving, and week-based grouping can produce incorrect rollups in some cases. This is a known platform limitation.
This approach works well when:
- You need a weekly view, but the week grouping is the only mode that breaks.
- You want the chart to still look weekly for reporting.
It may not help if:
- The underlying data itself is wrong.
- The values depend on complex relations or rollups that are unstable.
Practical tips for teams using Notion charts for reporting
- Keep a simple table view nearby (even hidden) that can be grouped by week as a cross-check.
- If the chart is powering an executive dashboard, add a note: “Weekly chart is using workaround due to grouping issue.”
Get help fixing your Notion reporting
If you want help troubleshooting a Notion dashboard or building reporting that stays accurate as your database grows, book a ZoomFlow session with a Connex consultant. We'll debug the chart behavior with you on a single call and leave you with a working setup.
Related Posts
How to consolidate Asana and Slack tasks into one Notion to-do list
Learn a simple system to pull tasks and messages from client tools like Asana and Slack into one Notion to-do list, so you can work from a single dashboard.
Notion Slack notifications: what changed and 5 workarounds
Notion Slack notifications changed for many teams. Learn what likely changed, what is still supported, and 5 practical workarounds using automations.
