Grouped data in BarSeries

5 posts, 1 answers
  1. Francois
    Francois avatar
    6 posts
    Member since:
    Nov 2013

    Posted 25 Apr 2014 Link to this post

    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?

    <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>
  2. Answer
    Danail Vasilev
    Admin
    Danail Vasilev avatar
    1493 posts

    Posted 30 Apr 2014 Link to this post

    Hello,

    I am sorry to say that the desired functionality is not supported by the RadHtmlChart control. If we receive other request on this regard we may consider its implementation for the future.

    Regards,
    Danail Vasilev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Francois
    Francois avatar
    6 posts
    Member since:
    Nov 2013

    Posted 16 May 2014 Link to this post

    Hello Danail,

    Can we put in a request somewhere on a wishlist or something?
    Thanks,

    Best regards,
    Francois
  5. Danail Vasilev
    Admin
    Danail Vasilev avatar
    1493 posts

    Posted 20 May 2014 Link to this post

    Hello Francois,

    You can use our feedback portal, where you can log your ideas about Telerik UI products.

    Regards,
    Danail Vasilev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Danail Vasilev
    Admin
    Danail Vasilev avatar
    1493 posts

    Posted 04 Jul 2014 Link to this post

    Hello Francois,

    This feature request is logged here, so that you can monitor, track its progress and raise its priority by voting on it.

    Regards,
    Danail Vasilev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017