Execute the following query and see the resulting pie chart. The placement of the labels are not very good ...
select 'United States' as country, 65 as revpercent
union
select 'United Kingdom' as country, 15 as revpercent
union
select 'Germany' as country, 15 as revpercent
union
select 'Canada-1' as country, 1 as revpercent
union
select 'Mexico' as country, 1 as revpercent
union
select 'Chile' as country, 1 as revpercent
union
select 'Spain' as country, 1 as revpercent
union
select 'Belgium' as country, 1 as revpercent
GO
.setPivotResultSettings 'Index=1,
RowFields="[country] {None,SummaryCount,GrandCount}",
DataFields="[revpercent] {None,SummarySum,GrandSum} ASC",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=425,
Chart="{pie}",
RotX=334,
RotY=7,
RotZ=0,
ZoomScalar=0.85,
ShowLegend=true,
ShowLegendBorder=true,
ShowGrid=true,
FillGrid=true,
GridLineWidth=1.0,
Title="",
TitlePosition="Bottom Center",
TitleCategory="",
TitleValue="",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=0.0,
PieLabelDistance=3.0,
PieShowLines=true,
LineWidth=1.0,
ShowMarkers=true,
MapShowBackground=false,
MapShowDetails=false,
MapRange="",
MapRangeColors="",
Width=16.0,
Height=10.0,
Depth=5.0,
SeriesSpacing=1.0,
CategorySpacing=1.0,
Font=Dialog-BOLD-10,
LegendFontSize=1.0,
SeriesFontSize=1.0,
CategoryFontSize=1.0,
ValueFontSize=1.0,
TitleFontSize=1.75,
AxisTitleFontSize=1.25,
DataLabelFontSize=1.0,
TopColor=#ebf0f5,
BottomColor=#d7dcf5,
PanX=-53.0,
PanY=70.0,
Lighting=Default,
Opacity=1.0,
View2D=true,
FitChartToImage=false,
StackedPercent=false,
ShowValueAxis=true,
ShowValueAxisTicks=true,
ShowValueAxisLines=true,
ReverseValueAxis=false,
ShowCategoryAxis=true,
ShowCategoryAxisTicks=true,
ShowCategoryAxisLines=true,
ShowSeriesAxis=true,
ShowDataLabels=false,
ValueAxisNumberFormat="",
CategoryAxisNumberFormat="",
CategoryAxisDateFormat="",
CategoryAxisDateTimeFormat="",
CategoryAxisTimeFormat="",
SeriesAxisNumberFormat="",
SeriesAxisDateFormat="",
SeriesAxisDateTimeFormat="",
SeriesAxisTimeFormat="",
NumericCategoryAxis=false,
MergeAxis=true,
SeriesAlias="default",
SeriesSubType="",
SeriesColumnType="Cube",
SeriesMin="default",
SeriesMax="default",
SeriesColor="default",
SeriesFunctionMetaData="true",
ShowSeriesDataLabels="false",
LegendPosition=Top Right,
LegendWidthType=Fit,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=false,
FixedCategoryCount=0,
ShowFields=true,
ShowTotal=true,
ShowSubTotal=false,
SortDataAscending=false,
SortDataRowIndex=1,
SortDataColIndex=0'
If I sort the data ascending the labels are placed well, but if I sort descending then they are not.
Currently, the pie draws the labels in 4 separate quadrants (NE, NW, SW, SE).
A simple fix for this would be to look for & populate unused space in adjacent quadrants.
e.g. in the attached pic, the slices are concentrated in the SE quadrant.
In this situation, the pie could distribute the labels between the NE & SE quads.
Currently, the pie draws the labels in 4 separate quadrants (NE, NW, SW, SE).
A simple fix for this would be to look for & populate unused space in adjacent quadrants.
e.g. in the attached pic, the slices are concentrated in the SE quadrant.
In this situation, the pie could distribute the labels between the NE & SE quads.
Issue #7886 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 32059 |
No time estimate |
If I sort the data ascending the labels are placed well, but if I sort descending then they are not.