Hello Telerik,
Currently I'm implementing a HtmlChart in asp.net. I'm translating a couple of excel sheets into asp.net.
please find attached two files. one of the excel example. one of the current barseries i've made up so far.
my question is: how can I bind grouped data? i want the Y axis to be displayed by year, and then by month. Now only the month is displayed.
could you assist me in defining the correct barseries?
Currently I'm implementing a HtmlChart in asp.net. I'm translating a couple of excel sheets into asp.net.
please find attached two files. one of the excel example. one of the current barseries i've made up so far.
my question is: how can I bind grouped data? i want the Y axis to be displayed by year, and then by month. Now only the month is displayed.
could you assist me in defining the correct barseries?
<
div
class
=
"LeftMonitorDiv"
>
<
telerik:RadPivotGrid
ID
=
"CAK_A1_PivotGrid"
runat
=
"server"
AggregatesLevel
=
"0"
AllowPaging
=
"True"
Culture
=
"nl-NL"
DataSourceID
=
"CAK_A1_UniekeClienten_Datasource"
UseQueryableDataProvider
=
"True"
ExportSettings-FileName
=
"CAK_A1_UniekeClienten"
ExportSettings-IgnorePaging
=
"True"
ExportSettings-OpenInNewWindow
=
"True"
Skin
=
"Metro"
PageSize
=
"20"
AllowFiltering
=
"False"
TotalsSettings-RowsSubTotalsPosition
=
"None"
TotalsSettings-ColumnsSubTotalsPosition
=
"None"
TotalsSettings-RowGrandTotalsPosition
=
"None"
TotalsSettings-ColumnGrandTotalsPosition
=
"None"
ShowDataHeaderZone
=
"false"
ShowFilterHeaderZone
=
"false"
ShowColumnHeaderZone
=
"false"
GroupTotalsVisibility
=
"None"
>
<
PagerStyle
ChangePageSizeButtonToolTip
=
"Change Page Size"
PageSizeControlType
=
"RadComboBox"
></
PagerStyle
>
<
Fields
>
<
telerik:PivotGridRowField
DataField
=
"Jaar"
UniqueName
=
"JaarColumn"
Caption
=
"Jaar"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridRowField
DataField
=
"Periode"
UniqueName
=
"PeriodeColumn"
Caption
=
"Periode"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridRowField
DataField
=
"ClientenUniek"
UniqueName
=
"ClientenUniek"
Caption
=
"Unieke Clienten"
>
</
telerik:PivotGridRowField
>
</
Fields
>
<
ClientSettings
EnableFieldsDragDrop
=
"false"
>
</
ClientSettings
>
<
ExportSettings
OpenInNewWindow
=
"True"
FileName
=
"CAK_A1_UniekeClienten"
IgnorePaging
=
"True"
/>
</
telerik:RadPivotGrid
>
</
div
>
<
div
class
=
"RightMonitorDiv"
>
<
telerik:RadHtmlChart
runat
=
"server"
Height
=
"338px"
Width
=
"563px"
Skin
=
"Metro"
CssClass
=
"CIZJeugdVervoerPieChart"
ID
=
"CAK_A1_UniekeClienten_PieChart"
Transitions
=
"true"
DataSourceID
=
"CAK_A1_UniekeClienten_Datasource"
>
<
Appearance
>
<
FillStyle
BackgroundColor
=
"White"
></
FillStyle
>
</
Appearance
>
<
ChartTitle
Text
=
"Unieke cliënten per periode"
>
<
Appearance
Align
=
"Center"
BackgroundColor
=
"White"
Position
=
"Top"
Visible
=
"True"
>
</
Appearance
>
</
ChartTitle
>
<
Legend
>
<
Appearance
BackgroundColor
=
"White"
Position
=
"Bottom"
Visible
=
"true"
>
</
Appearance
>
</
Legend
>
<
PlotArea
>
<
Appearance
>
<
FillStyle
BackgroundColor
=
"White"
></
FillStyle
>
</
Appearance
>
<
Series
>
<
telerik:BarSeries
Name
=
"Periode"
Stacked
=
"false"
DataFieldY
=
"ClientenUniek"
>
<
Appearance
>
<
FillStyle
BackgroundColor
=
"Red"
/>
</
Appearance
>
<
TooltipsAppearance
BackgroundColor
=
"White"
DataFormatString
=
"${0}"
/>
<
LabelsAppearance
Position
=
"Center"
DataField
=
"Periode"
/>
</
telerik:BarSeries
>
</
Series
>
<
XAxis
DataLabelsField
=
"Periode"
>
</
XAxis
>
<
YAxis
>
<
LabelsAppearance
DataFormatString
=
"{0}"
/>
</
YAxis
>
</
PlotArea
>
</
telerik:RadHtmlChart
>
</
div
>