IgxPivotGrid + IgxPivotDataSelector [Feature progress]

[ChronosSF]

Specifications

Data Operations spec: Pivot Pipes Specification
IgxPivotGrid spec: Pivot Grid Specification
IgxPivotDataSelector spec: TBA

Branch

Feature branch: https://github.com/IgniteUI/igniteui-angular/tree/pivot-grid-master

Tasks

Data Operations

• Specification
  • Test Plan
• Dimensions
  • Row Dimensions
  • Column Dimensions
  • Predefined dimensions
• Measures
  • Predefined measures
• Binding to data with complex objects

Pivot Grid Component

• Specification
  • Test Plan
• Filtering (depends on Spec)
  • Integrate flat excel style filtering
  • Integrate excel style filtering in a tree view (P2) - TBD separately
• Column Dimensions UI (depends on Spec)
• Row Dimensions UI (depends on Spec)
• IPivotDimensions update options
• Expand collapse states
• Formatting and measure styling
• Base Grid API Hiding
• Sorting
  • Sorting dimension values via chip.
  • Sorting data values via headers.
• Value aggregation selection via chip.
• Dimension selection
• Dimensions Cell Merging (P2)
  • Row dimensions merging - [Pivot] Cell merging for row dimensions #10800
  • Column dimensions merging - [Pivot] Cell merging for column dimensions #10801
• Keyboard navigation in headers
• Styling - @desig9stein
• Ultra-compact pivot density (P2)
• Dev Samples
  • Complex data dev sample
  • Remote data sample
• Create Sample - igniteui-angular-samples
• Improve scrolling performance
  • Clear old columns from view - Clear old columns from view when data has changed. #10502
  • Ensure that when columns are created for row dimensions while scrolling the grid does not repaint. - fix(pivot): Ensure that when columns are created for row dimensions w… #10739
• Allow resizing/auto-sizing the row dimension columns in case their text overflows - Allow resizing/auto-sizing the row dimension columns in case their text overflows #10811
• Allow resizing row dimensions - [Pivot] Allow resizing row dimensions  #10717
• Implement filtering chips dropdown in PivotGrid UI - [Pivot] Implement filtering chips dropdown in PivotGrid UI #10713
• Implement drop area for the chips UI in the pivot dimensions - [Pivot] Implement drop area for the chips UI in the pivot dimensions #10712

Pivot Data Selector Component

• Specification - @StefanIvanov

Documentation

• Write a topic for PivotGrid

Samples

• Create a sample

[kdinev]

Related #5700 #3514

[dkamburov]

@kdinev #3514 shouldn't be part of the PivotGrid efforts, yesterday there was a discussion about it and it will be difficult to implement the same merging functionality for the values of the grid and for the headers of the Pivot:

In PivotGrid there are cases when two adjacent equal values shouldn't merge(screenshot), while into the grid - all equal adjacent cells should be merged(this one is also bound with the sorting). So the pivot headers merging should not to be part of the base grid merging of the cells.

[kdinev]

I'm adding it only as related. I'm not suggesting to make it part of the pivot grid effort!