Data Studio
5.6K members online now
5.6K members online now
Ask questions about Data Studio
Guide Me

Pie chart filter not matching table data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Just getting started with a dashboard and I'm running into a sticky problem. I tried to apply a filter to a pie chart and noticed that the numbers weren't adding up, so I duplicated the chart and turned it into a simple table. The table adds up perfectly. I'm applying the following filter to data coming from Sheets:



The table matches my sheets data perfectly:


The pie chart includes 24 "other" entities, four of which, presumably, are the four departments not listed explicitly listed in the chart's legend. The other 20 are unaccounted for:


Any suggestions would be helpful. Thanks!