Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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 Image Modified - 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 Image Removed 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 Stream Function to Average
        • Update the Name to AvgLastBillAmount
        • Press 

...