Hi, I’m having an issue with a bar chart showing incorrect aggregated values. The chart uses FTDs by Position Group (a calculated field bucketing a POSITION column into Top 1-3, 4-10, 11-20, 21+) as the dimension and Total FTDs (a calculated SUM field) as the metric. All the values on each bar are incorrect. for example, the 21+ bar is showing ~42.7k when the correct value should be ~7.8k (verified against the raw data in Google Sheets). I have a page-level YEAR filter set to 2026 which works correctly on every other chart on the page. The chart is connected to a single Google Sheets data source with no second table in the blend. I’ve tried: rebuilding the chart from scratch, removing and re-adding YEAR as a dimension in the blend, and switching the metric from Total FTDs to raw FTDS - none of these fixed it. The Position Group calculated field uses a CASE WHEN statement and has a corresponding Position Order sort field. Any help appreciated!
1 Like