The Format Columns Dialog sets display parameters for columns in AQTime panels (Report, Details, Editor's grid, and others). There are settings for each column, and all columns can be set when the dialog is open. To open it, right-click on the header line and select Format Columns from the context menu:
The top-left listbox holds a list of columns, the rest of the dialog holds the settings for the column currently selected in the list. These settings are separated into the following tabbed pages:
For the numeric columns the available display formats are:
|Value||The measured result value.||Format String - defines how the value is displayed. For more information about the format string specifiers for numerical values, see Syntax of the Format String.|
|Percent||The percent value calculated relative to the total for this column.||Format String - defines how the value is displayed. For more information about the format string specifiers for numerical values, see Syntax of the Format String.|
|Bar Graph||A horizontal colored bar. The bar’s length is calculated relative to the total for this column.||Bar Color - specifies the color of the bar (default or as selected from a colorbox)|
|Color||A colored square mark. The fill color ranges from Zero Color to Max Color and it’s tint indicates the current percentage value.||Zero Color - a color that is to fill the values whose percentage is 0%. The default color is white.
Max Color - a color that is used to fill the values whose percentage is 100%. The default color is red.
For string columns you can specify only the Format String. For more information about the format string specifiers for textual values, see Syntax of the Format String.
If the summary and group summary fields are displayed, the values they hold will be a statistic (sum, average, minimum, maximum, count, and so forth.) calculated either from all the values or from the values of the group in the chosen column.
The Summary Kind section lets you choose how the summary and group summary are calculated (the group summary is calculated for each group when you group results by a column. The group summary is displayed at the end of each group node):
|None||No summary shown.|
|Min||Minimum value displayed in the column or in the group.|
|Max||Maximum value displayed in the column or in the group.|
|Average||Average value displayed in the column or in the group.|
|Count||Number of records (lines) displayed in the column or in the group.|
|Sum||The sum of all values displayed in the column or in the group.|
Each column of the Report or Details panel can have its own summary settings:
As you can see, the summary type for the Time With Children column is AVG while the summary type for the Time column is SUM (the word "SUM" is not displayed).