This repository has been archived by the owner on Mar 23, 2023. It is now read-only.

Basic Pivot and Aggregate Data

Jump to bottom

Paul Hammant edited this page May 6, 2015 · 2 revisions

Acceptance Criteria

Show Counts of loans by status

Given a list of loans with a variety of statuses
When a pivot is done on the status with a count as a calculated column 
Then there is one row per status
And a count for the number of loans matching that status is shown

Show Sum of loans by status

Given a list of loans with a variety of loan amounts
When a pivot is done on the status with a sum of the loan_amount column 
Then there is one row per status
And a sum of the matching loan_amount is shown

Show Sum of loans by status and sector

Given a list of loans with a variety of statuses and sectors
When a pivot is done on the status and sector with a count as a calculated column 
Then there is one row per status and sector permutation
And a count for the number of loans matching that status and sector is shown