This sample demonstrates rendering a pivot chart using pivot data. Users can explore the data through drill-up and drill-down operations by clicking the grouping labels. The field list can also be used to change the report at runtime.
|
|
In this sample, the Pivot Table component plots a chart widget based on the pivot report bound to it. This can be achieved by setting the property displayOption.view to Chart. The built-in options are: Table -> Renders pivot table widget only, which is the default. Chart -> Renders pivot chart widget only. Both -> Renders both pivot table and pivot chart widget. You can change the chart types using the Chart Types dropdown list separately. The chart types can be set using the chartSettings.chartSeries.type property. The built-in chart types are: Column Line Spline Bar Area StepArea SplineArea StackingColumn StackingArea StackingBar StepLine Pareto Bubble Scatter StackingColumn100 StackingBar100 StackingArea100 Polar Radar Pie Doughnut Funnel Pyramid In the sample, the field list option is enabled, through which you can see the result in the chart by altering the report dynamically. The drill down/up operation in the accumulation charts, such as pie, doughnut, funnel and pyramid, can be performed using the context menu on the click over the appropriate series. More information on the pivot chart can be found in this documentation section.