Links may not function; however, this content may be relevant to outdated versions of the product.
Adding columns to reports
Extend the report scope by including a property or a calculation in the report. For example, you can include a calculation that displays the difference in hours, days, or months between two dates of your choice.
- Run the report that you want to update.For more information, see Running a report.
- In the upper-right corner, click Edit report, and then add
columns:
Choices Actions Search for properties to add - In the Data Explorer section, in the search box, enter a property name, and then press Enter.
- Drag the property next to an existing report column.
Display the most suitable properties - In the Data Explorer section, click the Best Bets tab.
- Drag the property next to an existing report column.
Display all available properties - In the Data Explorer section, click the All Matches tab.
- Drag the property next to an existing report column.
Display SQL functions to use - In the Data Explorer section, click the Calculations tab.
- Drag the calculation next to an existing report column.
- In the Calculation builder modal dialog box, in the Function input field, press the Down arrow, and then select the property to calculate.
- Click Submit.
- Click Done editing.
- Sorting and grouping columns in list reports
Make your report more readable and organized by grouping columns and sorting the column values. For example, you can sort and group the report results to present the cases that the user accessed most recently.
Previous topic Creating report categories Next topic Sorting and grouping columns in list reports