Create a Change Report
Reporting on changes and analyzing trends has been greatly enhanced by using the new Dataset Reporting feature - see Create a Change Report from a Dataset
The legacy Report function displayed below is being deprecated in Versions after 6.0
Change Reports provide the ability to effectively analyze trends in data over a period of time.
This article describes how to create a Change Report utilizing the Metric Insights application.
Prerequisite: A Snapshot Report must be created in order to perform data analysis within a Change Report. Learn how to create a Snapshot Report
Tip: A more simplified process is now available for Creating Change Reports - see: Create a Change Report from Dataset
1. Access New > Report
In this example, we create a Change Report using the method in Step 2.2
- Input a unique Name
- Choose the Change Report option
- Select the Snapshot Report from the Source Report list
2. Input Definitions
2.1. Key Fields
In this example, we use Product Name as the identifier to base our comparison.
Add any desired Filters:
- Click + Add Filter
- Select the Report Instance to compare
- Select Column to compare
- Choose Filter option
- Select the basis on which to compare
- Input desired Value for comparison
In this example, we are looking for items whose prior order amount is more than 25% of the current order amount.
2.3. Columns to fetch
Select the Columns to be displayed in the Change Report
2.4. Report Columns
Optionally, the Report display can be customized using the following options:
- Modify the Display Name of the column header
- Select to have values appear as Currency
- Format numeric value display
- Enter a Description that will be displayed on hover of the column
- Select the columns to appear in the Results
- Choose to have Totals displayed for numeric data
- Modify the display order of the columns on the Change Report
- Add a custom formatted field to the report if you like
2.5. Update Report History
Select "no" unless you have made changes to the Report definitions since the last run.
3. Change Report Published and displayed in Viewer
- The report is displayed in the Viewer with the current run selected. To view results for a previous run, select a prior run date from the drop-down.
- Comparison values are displayed based upon the filter created in step 3.2 .