In order to create a meaningful table, you need to measure something. For example, using the sample Retail Banking dataset, 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 dataset. 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 dataset, 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 dataset 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):
The following example table shows the Product Type field (from the Accounts table) against the Gender field (from the Customers table). The default summation (a count of the number of customers) has been applied; you can see this by checking the details in the Filters.
Because this table is counting customers, 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):
To see how many credit card accounts are held, we need to add the count of accounts to the table instead. The following example shows that there are 19,523 credit card accounts held by the 17,344 individual males who have accounts:
Available Summation Options
The available summation options are shown at the top of the tree in the customise table panel. Select an option and then click Add to Row, Column, Filter or Wafer to add it to the table.
The available options will depend on the dataset 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 - this option allows you to add quantiles or create custom ranges.