Source Column
When adding columns to a report PDQ Inventory will only allow columns from data sources that are applicable. For example, if the table includes a column from the Applications table then it cannot also include columns from the Hot Fixes table.
Summary
Each column can be displayed as a summary which results in a single value that summarizes the data relative to the other non-summary columns in the report. Not all summaries are available for all data types.
Summary |
Column type |
Description |
Count |
All |
A count of the unique values within the column. |
Sum |
Number |
|
First |
Text, Date/Time |
The first item alphabetically (for text) or chronologically (date/time). |
Last |
Test, Date/Time |
The last item alphabetically (for text) or chronologically (date/time). |
Average |
Number |
|
Minimum |
Number |
The smallest value. |
Maximum |
Number |
The largest value. |