1 Reply Latest reply on Sep 25, 2012 10:58 AM by Tracy Rodgers

# How do you display a pie chart on a map (per State) but the total (Label) only shows 1 value?

Hello,

We have a map of the US.  Each state has a pie chart with how many votes for Democrat/Republican.  i.e. Rhode Island has 30k for Republican and 70k for Democrat so the pie chart shows 70% of the pie for Democrat and 30% for Republican.  We also have the Label (under 'Marks') = 'NumberOfVoters' -- so it displays 30,000 next to the Republican slice and 70,000 next to the Democratic slice -- on the map.  But, we do not want the Label to display for each slice -- we just want the total of all slices displayed.  i.e. 100,000.  So, if there are 3 'slices' of the pie chart we do not want 3 different labels -- we just want 1 label with the total of all 3 slices combined.  Is this possible?

Please see image below -- for California we do not want 309.8 and 56.8.  Just want one label which displays 366.6.

Any help greatly appreciated.

Thanks,

Dan

• ###### 1. Re: How do you display a pie chart on a map (per State) but the total (Label) only shows 1 value?

Hi Dan,

You can do this by creating a calculated field similar to the following:

total(sum([NumberofVoters]))

Place this calculation on the label shelf (it may be necessary to edit how the calculation is being computed, to do this right click on it and select Compute Using). Then, click on the upside down arrow next to Label on the marks card, and select Marks to Label: Max/Min. Under Options, check only the Label maximum value box.

Hope this helps!

-Tracy