Report Columns

A column of data in an Integrify report may be anything for the value of a question submitted on the form to the first name of the individual who started a request.

In this section we will discuss:

• Adding a column to a report

• Deleting a column

• Changing Column Names

• Manipulating Column Width

• Editing Column Format

• Define Column Sorting

• Adding Aggregates

Adding a Column

To view the available columns on a report, select the Columns tab:

The Columns tab will have a listing of all the columns that have been selected for this particular report.

To add a new column to a report, select the Add Column button. You will be presented with the following dialog:

Similar to the transition editor while configuring rules on a process you will have the option to select from various Sources within the process (or processes) to select data.

This dialog will be dynamic based on the Source selected. For instance, if you were to select Data as the source then the dialog will change and present you with a list of available tasks in the process to select, and then data attributes associated with the task. Note: if reporting against more than 1 process, you will be presented the option to choose the process before the list of tasks are displayed.

In the above example, a form task called ‘Enter Loan Request Information’ was selected and the Field options are the list of available questions on that particular form which you may have displayed on the report.

The following is a high-level breakdown of each available Source :

NOTE: By nature, Any Data queries are non-indexed, full table scans. Use Any Data thoughtfully as it can result in poor performance.
Current Task | Option to define the attributes for the current task. Commonly used to view how many tasks are assigned to users, total counts of tasks, time between task assignments and completions, etc.
Data (Matching Iteration) | Task reports can display and filter data or attributes from tasks corresponding to the iteration of the current task record. Also, iteration number can be displayed and filtered (choose under the Current Task source option to display as a column in a report). Useful for looping requests and displaying data from multiple tasks within each loop in the same row.
Fixed Value | Option to enter a fixed value associated to a task.
Task (Matching Iteration) | Task reports can display and filter data or attributes from tasks corresponding to the iteration of the current task record. Also, iteration number can be displayed and filtered (choose under the Current Task source option to display as a column in a report). Useful for looping requests and displaying data from multiple tasks within each loop in the same row.

For Task Reports , you can choose to include data from a current task or specific task that might be the due date, scheduled date, reminder date, or more. Or you can choose more data options that include Past Due information, or metric data.

Once you have selected the particular column you would like added, simply select Save on the column selection dialog and your column list will be updated.

Deleting a Column

Note: When deleting a column, check the column you want to delete and select the Delete Column option:

Changing Column Names

By default when a column is added to a report it will also be given a default column name based on the data it represents such as Data, Form Name, etc.

You may update this default name to be more relevant to your end-user by selecting theEdit pencil icon for the column you have added to your report and editing the Column Alias field:

Type the new Column Alias in the field provided and select Save.

Column Width

You can manipulate the width of the column by defining the width with a value such as below:

Column Format

You can control what the resulting format of the data field will be displayed as in the report. For example, if you want to display a link to a file that was attached in a field from a form, you can format the field to Attachment so the user running the report can open the attached file from the report view. See example:

And an example of the column’s links to the file attachments:

Formatting options include:

• String (Text)

• Date - will include a time along with the date.

• Date (UTC)

• Short Date - Will display only the date.

• Time - Will display only the time in hours and minutes.

• Number

• Hyperlink - link to a hyperlink

• Attachment - link to an attachment

• Request Link - link to a request

• Task Link - link to a task

Sorting Columns

Choose to have a column ascend or descend when running the report (for example, you could have it descend by the Amount column).

Adding Aggregates

To add an aggregate function such as sum, min, max, average, or count on a particular column, start by selecting the aggregate field:

You will be presented with a list of available functions that may be applied to a given column. Simply select the aggregate function you would like to use and press Save when you are complete.

How aggregate functions are applied will also depend on the other columns that have been selected on the report. For instance, if you were to select to display the Request ID value and Sum on a cost value that would be a question on the form, the reporting engine would be unable able to aggregate the value properly because the Request ID is a unique value:

However, if you were to select a value such as the Last Milestone which may only be represented as a single value within a given request, then the reporting engine can perform a Sum on the same cost value:

Always ensure the other columns are reporting when using the aggregate functions are values which common across multiple requests and group accordingly.