Hi John.

If you want to show stuff when you "move the cursor over a portion of the chart" then you need to edit the Tooltips (on the menu bar: Edit/Tooltip). You can use the 'Insert' pull-down menu to add any available (in the view) field. If you don't see something you want to use, just exit and drag that field to the level of detail shelf. Then it should show up in the Insert menu.

If you want to point arrows at stuff rt-click on it and go to the 'annotate' menu. 'Point' will give you an arrow and text box with a label. Both are movable later on. (See attached)

As to multiple labels shown simultaneously based on the label shelf content, you can do it, but you're probably getting into calculated fields. Hope this helps.

--Shawn

My problem with calculated fields is it won't let me combine a dimension with a metric. Example: Job Type and Revenue combined in a label.  I get an error "can't add string and float values" when trying to create the calculated field.

Hi Jason,

One option is to convert the Revenue field to a string value. You can further manipulate how the string of Revenue will be displayed. For example:

[Job Type] + ' $' + left(str(sum([Revenue])), 4)

Hope this helps!

-Tracy

This example workbook might help. Use calculated fields to show both % of total, and actual values, in a pie chart

Thanks Tracy. But now when I create the calculated field, I get this error:

"Cannot mix aggregate and non-aggregate arguments to function." 

Here is what the formula looks like after editing to add the proper dimensions:

[Job Function] + left(str(sum([Number of Records])), 4)

Hi Jason,

This should work:

attr([Job Function]) + left(str(sum([Number of Records])), 4)

-Tracy

Hello ,

Has someone idea if i can link a section from a pie chart to other pie chart (in the seame window from dashboard to open the pie chart of the section i selected) ?

like this?

No, i found a tutorial how to do your way , but i'm asking how about to duble click(or click) on a section and in the same sheet to change from continent to country let's say. (Like we have : Europe , Afriaca , Asia ... and we select Asia and whant to se in new pie chart the procent of populantion / country from Asia in the same sheet in new pie chart.) It is posible ?

Thanks Paul Greenspan!

Thanks to all!

I have used custom geocoding identifying certain company "sites." For each site I have a pie chart. I would like to label each pie chart with the site name (just once), but currently the labels are for each slice of the pie--not the whole pie. Any ideas?

If I annotate <Site> at the "mark" level, each slice is annotated, if I annotate the "point" level, <Site> results in "All" even though there's only one site for that particular pie chart...

Any help would be appreciated!