Summaries Specification

Summaries allow you to display data summaries within its container.

As a developer, I want to:

• implement total summaries per column

• have automatically preset defaults, depending on the type of data in the column. And to be able to modify/edit/delete them:

  • numeric: min, max, average, sum, count
  • string: count
  • date: latest, earliest, count

(count - counts all cells that are Not empty)

provide UI for the user to toggle on and off total summaries in a grid

• provide UI to enable the user to switch on and off summaries per column per summary function.
• display the summary results in a container. If the summaries are not switched on by default, the container is hidden. The container shows when summaries are switched on.
• position the summary results in a container that is bottom fixed above the pager and below/above? the horizontal scroll.

As an end user, I expect

• 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
• summaries to be relevant to the type of data per column
• a summary result of a column shows a label and a value. Positioned right below the column in a summary results container
• each summary should be positioned on a separate row
• that if a column is moving the summaries move accordingly
• that editing a cell will automatically update the total summaries
• that hiding/deleting/modifying a column will hide/delete/modify its total summaries accordingly
• that sorting will not to change my summaries values

UI and Behaviour

• display an icon in the column header of columns that have summaries available
• provide multiple selection of predefined summary options in an OperationUI
• summaries's results are aligned as the data in the corresponding columns (left, right, centered).
• each summary has a summary label(min/max etc)
• all similar summaries are positioned in one row, e.g. min first row, max second row.
• all summaries labels are left aligned.
• the order of summary labels is corresponding to the order of the summaries in the switch on/off menu in the header.

TBA

• support min occurrence/max occurrence for string
• support inGroups summaries
• implement filtered summaries
• change the position of the summary results (top, topfixed, bottom)
• implement custom functions
• support an advanced summary results container that adjusts it's size and layout to the number of summaries switched on

Limitations

Accessibility

ARIA

API

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