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.
- Run the report that you want to update.For more information, see Running a report.
- In the upper-right corner of the screen, 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 dialog box, in the Function input field, press the Down arrow key, and then select the property to calculate.
- Click Submit.
- In the upper-right corner of the screen, 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 a report category in Report Browser Next topic Sorting and grouping columns in list reports