Advanced Grouping
Advanced Grouping

In ERS, all reports and exports run off the data groups that you set up. Data groups allow you to group and filter your QCC files in different ways to produce various reports. Groups consist of the dimensions of one or more QCC files filtered in several different ways in the order you choose. If you are in the Interactive Analysis screen and tell ERS to memorize your report, it will create the group for you saving you the time of setting it up. Of course, you can always edit it later.

Choosing Dimensions

In each QCC file within the group, you choose the dimensions you want to use in your report (since you may not want all of them). In addition, you may want to flag some of them as critical. When the report runs, these may be set aside depending on the report type.

Cycling Filters

After choosing dimensions across one or more QCC files, you add a series of "cycling" filters that will be used to group your data in various ways when the report is run. For instance, you may want to run a report by month for the third quarter. In this case, you would set up 3 cycling filters for July, August, and September. When the report is run on that group, the data is first filtered for July and calculated, then for August, and finally for September.

Cycling filters can be any filter you have created and you can mix, match, and order them as desired to make your report. When setting up the report, you can then add an global filter to the cycling filters giving you a second level of filtering. For example, using the sample below of months as cycling filters, you could apply a global filter of "Machine 5". Now when your report runs, it will first filter the data down to just Machine 5 and then look month over month to get Cpks or other data. Conversely, you can use Machines as your cycling filters (for example, Machine 1, 2, and 3). Then use "Last month" as your global filter to just compare the machines for the past month. The options are limitless.

The screen shot below shows an example of a group in the Group Configuration screen. There is also a Group Wizard to help lead you through the individual steps of setting up a group.