[Draft] Pivot Data Selector Specification

Pivot Data Selector Specification

Owned by

Team Name

Developer Name

Stefan Ivanov

Requires approval from

Peer Developer Name | Date:
Design Manager Name | Date:

Signed off by

Product Owner Name | Date:
Platform Architect Name | Date:

Revision History

Version	Users	Date	Notes
1	Names of Developers and Designers	Date

1. Overview

Objectives

Define the high-level goals End-to-end user experience prototype

Acceptance criteria

Must-have before we can consider the feature a sprint candidate

...

2. User Stories

Elaborate more on the multi-facetted use cases

Developer stories:

Story 1: As a developer, I want to…, so that I can… prototype
Story 2: As a developer, I want to…, so that I can… prototype
Story 3: As a developer, I want to…, so that I can… prototype

End-user stories:

Story 1: As an end-user, I want to drag a data column to the filter area, so that I can configure criteria and show records satisfying them.
Story 2: As an end-user, I want to drag a data column to the rows area, so that I can define a pivot data selector of type rows.
Story 3: As an end-user, I want to hover on a data column and assign it to rows, so that I can quickly configure the pivot state without dragging stuff around.
Story 4: As an end-user, I want to choose a sort order for the rows, so that they can appear ASC or DESC.
Story 5: As an end-user, I want to drag a data column to the columns area, so that I can define a pivot data selector of type columns.
Story 6: As an end-user, I want to hover on a data column and assign it to columns, so that I can quickly configure the pivot state without dragging stuff around.
Story 7: As an end-user, I want to choose a sort order for the columns, so that they can appear ASC or DESC.
Story 8: As an end-user, I want to drag a data column to the columns area, so that I can define a pivot data selector of type values.
Story 9: As an end-user, I want to hover on a data column and assign it to values, so that I can quickly configure the pivot state without dragging stuff around.
Story 10: As an end-user, I want to choose an aggregation function for the values from a predefined list, so that my aggregates for one column are SUM and for another AVG.
Story 11: As an end-user, I want to drag pivot selectors from one area to another, so that I can change the type of pivot selector e.g. from rows to columns.
Story 12: As an end-user, I want to drag pivot selectors away from the selector pane, to remove them from the state of the pivot.

3. Functionality

Describe behavior, design, look and feel of the implemented feature. Always include visual mock-up

3.1. End-User Experience

The igxPivotGrid provides means to configure the pivot state via a vertical panel UI called data selector that appears adjacent to the grid before or after it. Besides a searchable list with the grid data columns, there are also four expandable areas underneath for filters, rows, columns, and values. Drag and drop is possible between those 4 areas, as well as from the data columns area at the top to any of the four areas below it. Each area offers actions specific to its items such as an icon to change the sort order or aggregating function for the values.

An action strip is shown upon hovering any column name at the top containing an action for assigning the column to one of the four pivot selectors: filters, rows, columns, and values.

HANDOFF

3.2. Developer Experience

3.3. Globalization/Localization