In the Caption window you have an option "insert" to embed the objects.
Please find the attached doc and let me know if this is what you are looking for.
caption.docx 55.5 KB
Sarath - Yes 'Insert' option is there but scenario here is ....
I have created Pie chart and Annotation below that (also I have caption). So Annotation and Caption is having 'Insert' option. I have created Pie chart by using calculated field say 'X'.
'X' field is having values - 10,20,44,65,77,37,-91,-88,-4,-51
1) I want to show Sum of negative values in Annotation. I have tried '<SUM((% Change V (YTD)) < 0)>' but not working.
2) I want to show SUM of field other than 'X' .
3) I want to show MAX / MIN value of other field.
Please let me know the steps to follow.
I am using Tableau 7
To achieve your requirement I would suggest you to use all the fields into the worksheet since you are trying to pull out the things other than present in worksheet(you can simply drag them to level of detail) and also request you to attach the workbook if possible.
Hi Rajeev -
I think you meant to upload a *.twbx (packaged workbook) but uploaded a twb instead - since the twb doesn't include data, (twbx does) we can't use it.
Please save your sample as a twbx and upload again?
Please explain the exact numbers you want showing up in your caption (Degradation YTD, Improvement YTD, Delta) and how they are calculated based on the data in your sample.
Degradation YTD = Sum of all negative values (< 0) from '% Change V (YTD)' field
Improved YTD = Sum of all positive values (>= 0) from '% Change V (YTD)' field
Delta = Sum of 'Delta (YTD)' field.
1 of 1 people found this helpful
We don't support "floating" areas inside other charts in version 7 (in the upcoming version 8 we do), so your caption needs to be created as a crosstab which looks like a legend. I''ve done this in the attached workbook and put it directly below your pie chart.
The SUM on your measures is returning odd looking values - perhaps you wanted an AVG? I used SUM, however.