Bars or Sparklines in Pivot?

1 Answer 19 Views
PivotGrid and PivotFieldList SparkLine
Rolf
Top achievements
Rank 1
Rolf asked on 18 Aug 2022, 10:06 AM

Hello,

I haven't seen this in the demos or documentation (yet?). is it possible to display bars, lines or sparklines in the cells of a pivot grid ? is this supported by a public method or property? can this be programmed? is this difficult or extensive?

thanks in advance

Rolf Kaleveld

1 Answer, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 22 Aug 2022, 11:23 AM

Hello, Rolf,

RadPivotGrid offers integration with RadChartView. Additional information on this topic is available in the following article:

https://docs.telerik.com/devtools/winforms/controls/pivotgrid/binding-with-radchartview

You can also refer to our Demo application >> PivotGrid >> Binding with RadChartView example which is quite useful on this topic.

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

The Premier Dev Conference is back! 

Coming to you live from Progress360 in-person or on your own time, DevReach for all. Register Today.


Rolf
Top achievements
Rank 1
commented on 23 Aug 2022, 07:01 AM

Hello, Dess,

thank you for your answer.
we are not looking for a chart next to the pivot grid, but for a bar within a cell of the privot grid. the bar could represent the procential part of the cell value in comparison to the grand total of the column. the demo doesn't show this or does it?

Regards,

Rolf

Dess | Tech Support Engineer, Principal
Telerik team
commented on 25 Aug 2022, 06:46 AM

Hi, Rolf,

The previously referred demo doesn't show charts inside each separate pivot cell. It demonstrates an integration between the selected data in RadPivotGrid and RadChartView.

Note that RadPivotGrid offers the CellCreating event which allows you to replace the default PivotCellElement with your custom one. In the PivotCellElement derivative you can override the CreateChildElements method where you can add whatever RadElement you need. Then, override the SynchronizeProperties method in order to adjust the custom element with the currently associated data.

However, such an approach is not recommended as it may affect the pivot's performance and smooth scrolling due to the  big number of visual cell elements in the pivot. That is why I suggested the chart integration.

Tags
PivotGrid and PivotFieldList SparkLine
Asked by
Rolf
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or