ChartArea and Pie Chat integration with PivotGrid

[Shilpa]

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.

[Danail Vasilev]

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

[Shilpa]

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.

[Danail Vasilev]

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

[Shilpa]

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.

[Danail Vasilev]

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

[Shilpa]

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

[Shilpa]

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.

[Danail Vasilev]

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

[Shilpa]

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

 

[Danail Vasilev]

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