Summary:
When viewing the Analytics dashboard charts for a long date range, the chart only displays data up to a certain earlier date. This behaviour occurs because the chart truncates results when too many data points are returned, affecting both the plotted data and axis values. The issue is not planned for near‑term changes. To work around it, use shorter date ranges, add filters, or pre-aggregate data via SQL Data Explore
Symptoms:
- When setting the charts on the Analytics dashboard to a long date range, for example, from 1 January 2025 to 29 October 2025, and the graph only shows data up to July 24.
- Expected behaviour is that the graph displays data for the entire selected period.
- Similar truncation occurs on long time spans, with chart and axis values not matching the full requested range.
Cause:
The charting component truncates data when tens of thousands of rows are returned for a single query. With very large result sets, the visualisation limits the number of data points it will render, which results in incomplete time-series coverage and misaligned axis values for long date ranges.
Resolution:
- Reduce the selected date range so fewer data points are returned; the chart will then display correctly.
- Apply additional filters (e.g., by campaign, country, platform, or other dimensions) to limit the volume of data returned.
- Use SQL Data Explorer to pre-aggregate, filter, or sample the data, then visualise the summarised results instead of the raw, high-volume dataset.
- Be aware that this truncation behaviour is a known limitation and is not scheduled for immediate modification.