Now you will create a filter transform that only contains the top five states with the strongest sales.

Perform the following steps to create a transform that will filter the data appropriately:

1. Click Pipeline.
   The getting_started connection, the states feed, and the region_summary transform are displayed in the pipeline.
2. Click the gear icon button in the states feed box.
3. Select +, and then New Transform.
   A pop-up for choosing a transform type is displayed.
4. In the pop-up, select Filter.
   A new page is displayed.
5. In Transform Name, enter Top 5 States.
6. Turn the Enable Server Subscription toggle in order for data for this transform to be continually fetched, updated, and cached.
7. Click Next.
   You are taken to the Attributes tab.
8. On the Attributes tab, remove all attributes except for State and TotalSales by selecting the attributes and clicking Remove Attribute.
   
9. Click Next.
   You are taken to the Filter tab. No changes are needed here, so click Next to proceed.
10. On the Row Limit tab, enable the Row Limit toggle to limit the result to the specified number of records.
    A new field is displayed.
11. In Row Limit, enter 5 and click Next.
12. On the Sort tab, click + Add Sort to add a row.
    A new row is displayed.
13. From the drop-down, select TotalSales, and in Sort By, select Descending.
14. Click Next.
    You are taken to the Upstream Variables tab. No changes are needed here, so click Next to go to Preview. On the Preview tab, you can observe the table showing the total sales for the top 5 states in descending order.
15. Click Save and Close.
    The newly created filter transform is displayed in the pipeline.

Summary

You have connected to some sample data and created three different views of the data that can now be used in edgeCore. In the next exercise, you will create three types of visualizations that will present these data sets in meaningful ways to the user.

For more information on Transforms, refer to the corresponding chapter.