× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
NielsGron reported 2012-10-30T22:10:20Z  · SachinPrakash last modified 2013-05-07T20:07:16Z

Enhance Pie Chart label placement algorithm


Dev mattbrumley(*)
QA
Sachin Prakash
SachinPrakash
Priority Low
Complexity Unknown
Component App - Charts
Version 13.0

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'
 

 

2 attachments

Issue #7886

Closed
Fixed
Resolved 2013-04-25T17:34:33Z
 
 
Completion
No due date
Fixed Build 32059
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017