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

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:

 

Screenshot_1.png

The table matches my sheets data perfectly:

Screenshot_7.png

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:

Screenshot_8.png

Any suggestions would be helpful. Thanks!