Page Comparison

...

• Set up aggregate attributes on pipes
• Read aggregate attributes from pipes into a Streamstream

In this exercise you will create a report of total and average last billed amounts, aggregated by Region:

In your model, add a new

...

stream:

1. Hover over Customers in England, and press Image Modified

...

1. Add a new Stream
2. Give the new Stream the Name: Customer Summary by Region
3. Double-click on the new pipe to open the details form
4. Go to the

...

1. Sort/Group section:
   

...

1. • Open the list of attributes, and drag the attribute Region into the list of sorting/ grouping attributes
2. Go to the Aggregate Attributes

...

1. section:
   1. Press Image Modified to add a new aggregate attribute
   2. In the new aggregate attribute form:
      • Set the

...

1. 1. • Stream Function to Count
      • Leave the Attribute blank
      • Set the New Attribute Name to CountRecords
      • Press Image Modified
   2. Add another aggregate attribute:

...

1. 1. • Press Image Modified

...

1. 1. •  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

...

1. 1. • • Name to TotalLastBillAmount
        • Press Image Modified
   2. Add another aggregate attribute:

...

1. 1. • 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

...

1. 1. • • Stream Function to Average
        • Update the

...

1. 1. • • Name to AvgLastBillAmount
        • Press Image Modified

Now you need to configure your output Stream:

1. Drag the

...

1. attribute Region from the Sort/Group

...

1. section of the pipe onto the

...

1. stream Customer Summary by Region
2. Drag the aggregate attributes you added from the Aggregate Attributes

...

1. section of the pipe onto the

...

1. stream Customer Summary by Region
2. In the main pipe configuration form, press Image Modified

Remember to save your model layout.

1. Run

...

1. analysis on Customer Summary by Region
2. Have a look at the data in this

...

1. stream – check that the aggregated report has been generated correctly