Summation Options - SuperWEB2

In order to create a meaningful table, you need to measure something. For example, using the sample Retail Banking database, you can choose to measure a simple count of customers, or you can generate a table that calculates something more complex, such as the mean customer profit or the median account balance.

The Summation Options control what is being measured in the table. If you do not specifically add a summation option to your table, then SuperWEB2 will automatically add the default option set for that database. In the case of Retail Banking, the default summation option is a count of the number of customers. When you start creating a table from this database, SuperWEB2 automatically adds the default summation:

Understanding What is Being Counted

In many cases, the underlying data you will be working with in SuperWEB2 comes from multiple tables connected by relationships. For example, the sample Retail Banking database contains two connected tables: customer records and account records.

It is therefore important to understand what is being counted in your table. For example, with Retail Banking you might choose to count the number of customers or count the number of accounts. These will give different results (because customers can have more than one account):

If you do not specifically add a summation option to the table, then SuperWEB2 uses the default. The information at the top of the table tells you what is being counted.

The following example table shows the Product Type field (from the Accounts table) and the Gender field (from the Customers table). The default summation (a count of the number of customers) has been applied.

This means that (for example) the table shows that 17,344 males have at least one Credit Card product (it does not show the number of Credit Card products held by males):

In this case, the information in the table header tells you what is being counted.

Available Summations Options

The available summation options are shown at the top of the tree in the Customise Table section. Select an option and then click Add to Row or Add to Column to add it to the table.

The available options will depend on the database and how it has been configured, but they may include:

• Count - a count of the number of records.
• Mathematical operations, such as sum, median and mean.
• Range - allows you to add quantiles or create custom ranges.

Mean and median are only available if the administrator has enabled these statistical functions.