Summaries Specification

As a developer, I want to:

• implement total summaries;
• apply a function on all values in a column;
• apply preset functions depending on the type of data in a column:

Numeric - min, max, average, sum, count String - min occurrence, max occurrence, count Date - latest, earliest, count

count - counts all that are Not empty

- display the results ;

v3

• apply custom functions;

UI and Behaviour.

• display an icon that indicates column summary in each column header;
• display the total summaries in a footer, to visually define it as a different part of the grid and positioned right above the pager;
• display the different types of summaries on different rows in the footer or keep them on one row if there is one summary toggled on per column;
• implement different types of summary options per each column;
• Have defaults set per type of column
• toggle on and off specific, single column, row or total summaries in a grid;
• be able to add label to summaries that are not available or switched on;
• be able to choose if I want to update the summaries based on filtered input and change the label accordingly;
• can expect that if the column is movable the summaries will move accordingly;
• can expect that if the column is sorted the summaries will not change;
• can expect that if a column is edited or deleted the summary will update accordingly;

As an end user, I expect

• relevant options for summaries for each column. e.g., Min or max summaries are not relevant for a String column;

Numeric - min, max, average, sum, count String - most common, less common, count Date - latest, oldest, count

Count - not empty

• to see an icon in the column header that indicates column summaries option;

• to toggle on and off specific summaries of single column, or the entire grid;

• the summary of the column on to be a function of all column values, even if paging is applied;

• a summary of a column shows a label and a value. Positioned right below the column in a grid footer (above the pager?). Or in case of grouped columns next to the grouping. The footer should be defined as another part of the grid;

• if I have more than one type of summary per column. They are positioned on different rows or on the same row as long as there is one summary per column depending on my needs;

• If I have one type of summary pre each column to have them positioned in one row.e.g., 5 column having average Summary;

• to identify when there is no summary for that column;

• that if a column is moving the summaries move accordingly;

• the summary of the column to be re-calculated on applied filter or not depending on my needs;

• in case of filtered summary, the label to change (filtered summary) and to update the rest of the column summaries;

• that adding or deleting a row(s) will automatically update the total summaries;

• that editing a cell will automatically update the total summaries;

• that hiding a column will hide its total summaries as well;

• NOT sorting to change my summaries values or position;

https://www.igniteui.com/help/iggrid-enabling--column-summaries