Manage report columns and groupings

Manage columns

You can add, remove, and reorder columns.

Go to Reports

  1. In the upper-right corner of a report, click Options.
  2. Select Manage Report Columns.
  3. On the left, select a column and click Add.

    This adds the column to the report.

  4. On the right, select a column and click Remove.

    This deletes the column from the report.

  5. Reorder the columns by clicking the up and down arrows.

  6. Click Update Report.

    The report repopulates with the selected columns.

    Keep in mind that some columns are automatically added if other columns rely on them. For example, if you add Usage, Usage Type is also added.

Manage groupings

You can regenerate the report with the data grouped differently by adding, removing, or reordering the columns that are used for grouping the data.

  1. In the upper-right corner of a report, click Options.
  2. Select Manage Report Grouping.
  3. On the left, select a column and click Add. This groups report data this column.
  4. On the right, select a column and click Remove. Report data is no longer grouped by this column.
  5. Reorder the report groupings by clicking the up and down arrows.
  6. Click Update Report.

    The report repopulates with the selected groupings.

Manage columns for tags, customer fields, and cloud account fields

After you configure tags and fields, you can make them available to a report. Then you can add columns to your report based on the tags and fields that are associated with your cloud billing data.

Prerequisite

Configure tags, customer fields, and cloud account fields, as described in the following articles:

Make the tags and fields available

Before you can add columns that are based on tags and fields, you must make the tags and fields available.

  1. In the upper-right corner of a report, click Options.
  2. Select one of the following:

    • Manage Tag Columns
    • Manage Customer Fields
    • Manage Cloud Account Fields
  3. Click a tag or field name in the left column and click Add to make the tag or field available to be added as a column in the report.

  4. Click Update Report.

    You can now add the tag or field column to the report, as described in manage report columns.

    After you add a new tag or field column, you can select it and use it for grouping, just like any other column, as described in manage report grouping. When selected, the data is segmented based on which tag value is associated with the data. Data with no value for a given tag is grouped together.