The advanced function Growth Truncate displays the truncated growth between two metric fields as a percentage. It returns the truncated growth between two metric fields as a percentage and uses the truncate option to truncate our result.
The formula used for calculation is:
((Advanced function applied column - Column against growth calculated)/Column against growth calculated) * 100
Follow the example below to apply growth truncate function to a report:
- Login as an authorized user.
- Click on the Plus sign that appears at the top right corner and select Report.
- On the New Report window, click on a metric view that will form the basis of your analysis. Here, for instance Disposition is selected.
- On the report interface, add your required data fields. Ensure that you have a dimension and two metric field function to generate this report.
- To drag a data field in the Columns box, expand one of the folders that appear in the left pane of the report interface window and by using the click-and-drag method on the columns, populate the Columns box. You can use the search box, presented above the folders, to search for a specific column. Here, for instance, Study ID, Site Region, Sum Subjects Enrolled, and Sum Subjects Completed are selected.
- On the Advanced Function tab, in the Select Function box, select Analysis.
- Select Growth Truncate in the succeeding drop-down box. You can also search for the function by entering text in the search bar that is present above the drop-down box. Provide the following inputs:
- Metric Column: Allows you to select the target metric column, here, for instance, Sum Subjects Enrolled. The base metric on which the advanced function is applied here is, Sum Subjects Completed. In this scenario, the difference between them will be calculated and will be shown in percentage, that is, ((Sum Subjects Completed - Sum Subjects Enrolled)/ Sum Subjects Enrolled)*100.
- Truncate Rows: Allows you to truncate your result.
- Truncate Method: Allows you to select the method of truncation used, i) Top, ii) Bottom, iii) Above % Threshold, iv) Below % Threshold, v) Above Absolute % Threshold, vi) Below Absolute % Threshold. Here, for instance, Top is chosen and will be applied to the base field, that is, Sum Subject Completed.
- Truncate Limit: Allows you to specify a value in relation to the chosen truncate method. Here, for instance, the limit 3 is chosen.
- Click Save to save the changes. The resultant report is shown below:
- Open the field menu of the Sum Subjects Completed column and then select Format and then Edit.
- Enter the percentage symbol (%) in the Suffix box and click the Close icon to save the changes.
The resultant report is visible below.