Adding columns to reports

Extend a report scope by adding a property or a calculation. For example, you can include a calculation that displays the difference in hours, days, or months between two dates of your choice.

  1. Run the report that you want to update.
    For more information, see Running a report.
  2. In the upper-right corner of the screen, click Edit report, and then add columns:
    Choices Actions
    Search for properties to add
    1. In the Data Explorer section, in the search box, enter a property name, and then press Enter.
    2. Drag the property next to an existing report column.
    Display the most suitable properties
    1. In the Data Explorer section, click the Best Bets tab.
    2. Drag the property next to an existing report column.
    Display all available properties
    1. In the Data Explorer section, click the All Matches tab.
    2. Drag the property next to an existing report column.
    Display SQL functions to use
    1. In the Data Explorer section, click the Calculations tab.
    2. Drag the calculation next to an existing report column.
    3. In the Calculation builder dialog box, in the Function input field, press the Down arrow key, and then select the property to calculate.
    4. Click Submit.
  3. In the upper-right corner of the screen, click Done editing.