Page Comparison

...

• In your model, add a new Stream:
• Hover over Customers in England, and press press Image Modified - 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 tab Sort/Group:
  • Drag the Attribute Region from the left-hand box into the list of sorting/ grouping attributes
• Go to the Aggregate Attributes tab:
  • Press Press Image Modified to add a new aggregate attribute
  • In the new aggregate attribute form:
    • Set the Aggregate Function to Count
    • Leave the Attribute blank
    • Set the New Attribute Name to CountRecords
    • Press Press Image Modified
  • Add another aggregate attribute: press press Image Modified - Show the list of Attributes
  • Drag the attribute BILLAMOUNT into the aggregate attributes list

...

• • Update the name of the aggregate value:
    • Double-click on the new aggregate attribute
    • Update the New Attribute Name to TotalLastBillAmount
    • Press Image RemovedPress Image Added
  • Add another aggregate attribute: press Image Removed press Image Added - 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 Aggregate Function to Average
    • Update the New Attribute Name to AvgLastBillAmount
    • Press Image RemovedPress Image Added

Now you need to configure your output Stream:

• Drag the Attribute Region from the Sort/Group tab of the pipe onto the Stream Customer Summary by Region
• Drag the aggregate attributes you added from the Aggregate Attributes tab of the pipe onto the Stream Customer Summary by Region
• In the main pipe configuration form, press Image Removedpress Image Added

Remember to save your model layout.

...