Group data
Applies to: TBM Studio 12.0 and later
If a table has multiple rows with the same values in a column, you can group the table by that column. The data is aggregated based on the entries in the column. This can be useful when creating charts and tables in reports.
- Add a Group step to the data transform.
- Select one or more columns to group by.
Watch this demo video from Apptio Education Services: Troubleshoot "Various over Time" message. Or, browse all Apptio videos.
Example
Assume you have the table shown below:
You group the table by the Vendor column to get the table shown below:
The table is now organized by Vendor, and a new .Count field has been added. The .Count field shows how many entries are in each aggregated row. Because the AGI/LENI and LENI vendors have different values in the Equipment column, the column displays the three dots.
If there are empty fields in the column by which you grouped, a row will be displayed at the bottom of the table that has the following values:
| In this column: | This value is displayed: |
| The Group By column | Blank |
| .Count | Number of blank rows |
| Numeric columns | Sum of all rows with blanks in the Group By column |