When viewing an indicator or performance measure, you can compare its data to data from one or more other measures.
Note: For paid subscriptions that include variables, a variable can also be used as a comparative measure. This will be shown later in this article.
This example focuses on the measure “% of students who enroll in college.” This measure uses a custom frequency of Graduation years.
The goal is to compare this college-enrollment measure to two other measures:
- A measure that tracks reading levels
- A measure that tracks on-time graduation rates
These comparison measures must already be created in the system, must contain data, and must have the same reporting frequency as the measure to which they are being compared.
In the Relationships section, click Add Existing Measure.
In the Add Measure(s) To window, set the relationship to Comparee. To find the measures, you can filter by type, tags, or title, then click Search to see the results. Only measures that have the same frequency as the target measure will be available for selection. Select the measure(s) to compare and click Add.
The added measures are now listed under Measures to Compare on Graph.
Return to the graph and click Trend Line Comparison.
This adds the compared measures to the data graph. Each set of data is color-coded according to the key below the graph.
Note: Users with admin permission can change the default colors and line widths used in the trend line comparison graph.
The comparison can also be shown in Bar graph format.
You can Hide Labels or Show Labels, and turn off one or more trendlines by toggling the visibility icons in the graph key.
To return to the non-compared graph, click Show Primary Chart.
For paid subscriptions, variables can also be added as comparative measures.
Using the same college enrollment measure example, this time we’ll be comparing data to similar college data from another region.This data is contained in a variable.
In Relationships, click Add Existing Measure even when looking for a variable.
In the Add Measure(s) To window, choose Comparee, and leave the Type filter blank. You can still filter by tags or title.Click Search, and choose one or variables to add. (As before, only variables with the matching frequency will be available for selection.)
Return to the graph and click Show Comparison Chart.
This adds the variable data alongside the measure data.
