ChartArea and Pie Chat integration with PivotGrid

11 posts, 1 answers
  1. Shilpa
    Shilpa avatar
    29 posts
    Member since:
    Apr 2015

    Posted 25 May 2015 Link to this post

    Hi,

    I have below two questions:

    1. Can we increase the chart area as the number of SeriesItem increases the chart messes up. PFA image.

    2. Can I have any example or demo of RadpivotGrid inegration with PieChart, currently I am having integration with BarSeries and ColumnSeries(which are working fine) but pie chart is not working.

  2. Danail Vasilev
    Admin
    Danail Vasilev avatar
    1494 posts

    Posted 26 May 2015 Link to this post

    Hi Shilpa,

    Please find may answers to your questions below:
        - Increase the chart area to handle many items - In order to increase the plot area you can simply increase the height of the chart. I see also that there is gap/spacing between items/series.  You can also decrease them as per this article - http://www.telerik.com/help/aspnet-ajax/htmlchart-appearance-gap-and-spacing.html   
        - Pieseries integration with Pivot Grid - We have an integration with Column series here -  http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/applicationscenarios/chartintegration/defaultcs.aspx . You can, however, use the same approach to create the pie series as per your project's requirements and needs.

    Regards,
    Danail Vasilev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Shilpa
    Shilpa avatar
    29 posts
    Member since:
    Apr 2015

    Posted 27 May 2015 Link to this post

    Thanks for the response Danail Vasilev.

    But in case of Area i need it dynamic as the chart is created on runtime and i need to increase the area accordingly the number of series in chart.

  5. Danail Vasilev
    Admin
    Danail Vasilev avatar
    1494 posts

    Posted 27 May 2015 Link to this post

    Hello Shilpa,

    You can attach to the load event of the chart where you can use the JavaScript below to get the number of series and based on it resize the chart's width:

    $find('chartID').get_kendoWidget().options.series.length;
    $find('chartID').set_width(200);

    Regards,
    Danail Vasilev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Shilpa
    Shilpa avatar
    29 posts
    Member since:
    Apr 2015

    Posted 28 May 2015 Link to this post

    Thanks for response :)

    I have few more questions for RadGrid:

    1. If my X-Axis label is too long, i want to truncate the length of label and show the complete label on mousehover as tooltip. Is there any such option or any other option to tackle this issue ? PFA image(Image 1).

    2. My column name in RowField is too long that filter option is not visible. PFA image(Image 2).

    If I change the Layout to Side by Side it is fine but I need it in Stacked Layout as well, so can we have horizontal scroll bar in Row Fields ?

    3. In excel we can have the same column in Row/Column Field and Aggregate Field but here if we drag the column to Aggregate Field we are not able to have the same column in Row/Column Field.

  7. Answer
    Danail Vasilev
    Admin
    Danail Vasilev avatar
    1494 posts

    Posted 02 Jun 2015 Link to this post

    Hello Shilpa,

    Please find my answers to your questions below:
       - Handle long x-axis labels - You can use the "\n" line feed character to line break the long labels, as illustrated in this demo - http://demos.telerik.com/aspnet-ajax/htmlchart/examples/functionality/multiline-labels/defaultcs.aspx. As for displaying tooltips on hovering x-axis labels this feature is not supported.
        - Long column name in row field - You can not display a scrollbar in the row field. You can, for example inspect the HTML of the configuration panel and style it with CSS (e.g., set a larger width).
        - Same column for Row/Column field and aggregate filed. This is not support by the RadPivotGrid and I am not sure whether this is a reliable setup. Could you please provide us with such an example in MS Excel for example?

    Regards,
    Danail Vasilev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  8. Shilpa
    Shilpa avatar
    29 posts
    Member since:
    Apr 2015

    Posted 12 Jun 2015 Link to this post

    Thanks for the response Danail.

    Another thing : In RadPivotGrid I had enabled the EnableZoneContextMenu, i want to know if i can change the Header text of pop up opened on click of "Show Fields Window" menu item. PFA image

  9. Shilpa
    Shilpa avatar
    29 posts
    Member since:
    Apr 2015

    Posted 15 Jun 2015 in reply to Danail Vasilev Link to this post

    Hi Danail,

    In reference to the point 3. PFA image of excel where we can have same column in Column field and Aggregate field in Excel.

    Let me know if there is any work around to have the same functionality in RadPivotGrid.

  10. Danail Vasilev
    Admin
    Danail Vasilev avatar
    1494 posts

    Posted 17 Jun 2015 Link to this post

    Hello Shilpa,

    You can set the title of the window by initially accessing it and then utilizing the window client-side API like that:

    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script>
            Sys.Application.add_load(function () {
                $find("<%=RadPivotGrid1.ClientID%>").get_fieldsWindow().set_title("this is new window title");
                });
        </script>
    </telerik:RadCodeBlock>

    As for the duplicate field in the column and aggregate I wasn't able to achieve that behavior with MS Excel - you can drag fields but you cannot clone them. The same is with the RadPivotGrid. What I can suggest is that you define the setup through the markups, for example:
    <telerik:PivotGridRowField DataField="CRM" ZoneIndex="0">
    </telerik:PivotGridRowField>
    <telerik:PivotGridAggregateField DataField="CRM" Aggregate="Count">
    </telerik:PivotGridAggregateField>


    Regards,
    Danail Vasilev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  11. Shilpa
    Shilpa avatar
    29 posts
    Member since:
    Apr 2015

    Posted 06 Jul 2015 in reply to Danail Vasilev Link to this post

    Hi Danail,

     

    That window title code works great..

    I have another query :

    In the Filter Window I want to access the list as the HTML tags are not getting decode there.PFA image.

    Thanks

     

  12. Danail Vasilev
    Admin
    Danail Vasilev avatar
    1494 posts

    Posted 06 Jul 2015 Link to this post

    Hello Shilpa,

    I would suggest when you have different questions to open separate forum posts / support tickets, so that the corresponding forum members / support officers can answer your best. You can also provide small snippets with the control declaration that showcase the problematic behavior.

    Thank you for your cooperation.

    Regards,
    Danail Vasilev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017