You can summarize data by counting the records for each unique value, or unique combination of values, in one or more character or datetime fields. You can optionally subtotal numeric fields for each of these unique values.
To summarize data:
Select the field(s) to summarize from the Summarize On list.
Click Summarize On to select the field(s), or to create an expression.
If you select more than one field, the order in which you select the fields dictates the summarizing priority. The records are summarized by the first field you select, and within the resulting summarized groups the records are then summarized by the second field you select, and so on. Reversing the order in which you select two fields gives quite different results.
The order in which you select the fields is also the order in which the columns appear in the results. If you are appending results to an existing ACL table, the column selection and order must be identical to the column selection and order in the existing table.
The order in which you select the fields is the order in which the columns appear in the results. If you are appending results to an existing ACL table, the column selection and order must be identical to the column selection and order in the existing table.
Select the other field(s) to include in the output results from the Other Fields list.
Click Other Fields to select the field(s), or to create an expression.
Select only fields in which the same value applies to all items in a summarized group. For more information, see The Other Fields option.
You can summarize unsorted fields, but the results may contain more than one summarized group for the same value, which may defeat the purpose of summarizing. Depending on the nature of your analysis, summarizing unsorted fields may be appropriate.
The IF statement considers all records in the view and filters out those that do not meet the specified condition.
Screen – Select this option to display the results in the ACL display area. If the output table contains a large number of records, it is faster and more useful to save the results to a file than to display the results on the screen.
Print – Select this option to send the results to the default printer.
Graph – Select this option to create a graph of the results and display it in the ACL display area.
File – Select this option to save or append the results to an ACL table. The table is added to the open project if it is not already in the project.
Output options that do not apply to a particular analytical operation are disabled.
File Type – ACL Table is the only option. Saves the results to a new ACL table, or appends the results to an existing ACL table.
Name – Enter a table name in the Name text box. Or click Name and enter the table name, or select an existing table in the Save or Save File As dialog box to overwrite or append to the table. If ACL prefills a table name, you can accept the prefilled name, or change it.
You can also specify an absolute or relative file path, or navigate to a different folder, to save or append the table in a location other than the project location. For example: C:\Results\Output.fil or Results\Output.fil.
Local – Only enabled when connected to a server table. Select Local to save the output table to the same location as the project, or to specify a path or navigate to a different local folder. Leave Local deselected to save the output table to the Prefix folder on the ACL Server.
For output results produced from analysis or processing of ACL Analytics Exchange server tables, select Local. You cannot use the Local setting to import results tables to ACL Analytics Exchange Server.
Headers and footers are centered by default. Type a left angle bracket (<) before the header or footer text to left align the text. Click Header or Footer to enter a header or footer of more than one line. Alternatively, you can enter a semi-colon (;) as a line-break character in the header or footer text box. Left aligning multiple lines requires a left angle bracket at the beginning of each line.
All – This option is selected by default. Leave it selected to specify that all records in the view will be processed.
First – Select this option and enter a number in the text box to start processing at the first record in the view and include only the specified number of records.
Next – Select this option and enter a number in the text box to start processing at the currently selected record in the view and include only the specified number of records. The actual record number in the leftmost column must be selected, not data in the row.
While – Select this option to use a WHILE statement to limit the processing of records in the view based on a particular criterion or set of criteria. You can enter a condition in the While text box, or click While to create a WHILE statement using the Expression Builder.
A WHILE statement allows records in the view to be processed only while the specified condition evaluates to true. As soon as the condition evaluates to false, the processing terminates, and no further records are considered. You can use the While option in conjunction with the All, First, or Next options.
The number of records specified in the First or Next options references either the physical or the indexed order of records in a table, and disregards any filtering or quick sorting applied to the view. However, results of analytical operations respect any filtering.
If a view is quick sorted, Next behaves like First.
Select Append To Existing File if you are certain the output results and the existing table are identical in structure.
Leave Append To Existing File deselected if you want ACL to compare the record lengths of the output results and the existing table. If the record lengths are not identical, the data structure is not identical.
Leaving Append To Existing File deselected is recommended if you are uncertain about the data structure. For more information about appending and data structure, see Appending results to ACL tables and text files.
If you are expecting the Append option to appear and it does not, click No to cancel the operation and see Appending results to ACL tables and text files.