In This Topic
The following key features of FlexPivot would help developers in realizing their complex data analysis needs.
- Familiar Excel-Like Panel Design
FlexPivot is an easy-to-use control which is modeled after Microsoft Excel Pivot Tables, which makes it powerful and familiar for all users.
- Process Millions of Records in Milliseconds
Built on a super-charged data engine, FlexPivot offers a lightning-fast data engine that will give your users more power, speed, and reach than ever before. The C1DataEngine offers high-speed processing of very large datasets that makes it possible to reach high performance of up to hundreds of millions records in a fraction of a second. The engine also supports query operations such as Aggregation, Joins, Grouping, Filter, Unary/Binary operations, etc.
- All-in-One, Code-Free Data Analysis
Just connect the all-in-one page component to a data source and you have a complete analytical tool including the pivot panel, grid, chart and a toolbar. This allows you to dynamically create summarized views by dragging fields into the row, column, and value lists.
- Increase User Productivity
FlexPivot includes built-in save and load of views, which saves development time and increases productivity by giving more power to the end-user.
- Plot Information on Grid View
FlexPivot provides the FlexPivotGrid control to display data in a grid-like view enabling you to customize your FlexPivot application. See the Architecture section for an overview of the FlexPivotGrid control.
- Group and Aggregate Data Instantaneously
FlexPivot enables users to group and aggregate data across the top or down the side of the grid.
- Filter Data Dynamically
FlexPivot enables you to filter data based on some conditions using value, range-based and TopN filters so that the you can simply right-click on the fields to filter and select Field Settings.