Page Comparison

...

• Hover over Customers in England, and press  - Add a new Stream
• Give the new Stream the Name: Customer Summary by Region
• Double-click on the new pipe to open the details form
• Go to the Sort/Group section:
  
  • Open the list of attributes, and drag the attribute Region into the list of sorting/ grouping attributes
• Go to the Aggregate Attributes section:
  • Press  to add a new aggregate attribute
  • In the new aggregate attribute form:
    • Set the Stream Function to Count
    • Leave the Attribute blank
    • Set the New Attribute Name to CountRecords
    • Press 
  • Add another aggregate attribute:
    • Press  -  Show the list of Attributes
    • Drag the attribute BILLAMOUNT into the aggregate attributes list
    • Note that this already uses the attribute function Sum – leave this as it is
    • Update the name of the aggregate value:
      • Double-click on the new aggregate attribute
      • Update the Name to TotalLastBillAmount
      • Press 
  • Add another aggregate attribute:
    • Press  -  Show the list of Attributes
    • Drag the attribute BILLAMOUNT into the aggregate attributes list
    • Update the details for this new aggregate attribute:
      • Double-click on it
      • Update the Stream Function to Average
      • Update the Name to AvgLastBillAmount
      • Press 

...