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.
Users can also user a parent measure to only show comparison data. If the parent measure that the user is adding comparee measures to is not calculated and does not have it's own data set, the user can go to the Graph Settings to activate the comparison.
The user will need to set the option of Display Comparison to "On" in order for the data for the measures added to the "Measures to Compare on Graph" section to show the comparison data on the graph.
A Grouped Comparison view is now available for graphs in parent measures with disaggregated measures. The grouped summary shows the graph data grouped by measure and showing the various time periods collected for each measure in a grouped display. The "Grouped Comparison" view also provides a data grid which shows the data collected for each measure and period. This view provides users with a high-level snapshot of the data collected for the parent and disaggregated measures without the graph displaying the data over a longer timeline.
-
-
In order to access the Grouped Comparison option, users can click the "Comparison" button displaying above the graph and then select "Grouped Comparison"
-
-
- When viewing the Group Comparison, users can utilize the page icon in the upper right corner of the Group Comparison view to export the graph or data through multiple format options.