Skip to main content

Working with Report Data


Analytics by Liaison reports present an interactive visual representation of data (i.e., visualizations). Reports include tools that allow the user to display specific information and perform more detailed analysis to better understand trends and draw conclusions about correlations and causality. This includes the ability to export and download the raw underlying data for use outside of Analytics by Liaison. The following sections outline the tools available for the following reports:

360 Dashboard

After you log in to Analytics by Liaison, the 360 Dashboard is the first report you see. It's designed to provide an overview of key applicant metrics.


Data Labels 

Labels are numeric or descriptive values displayed next to or on top of sections of the visualizations. They are relevant to the specific section of the visualization (i.e., a bar in a bar chart, a line in a line chart, a state on a map, etc.) and represent the underlying value or a related description. Examples of data labels are as follows:

Data - Right Side.png
Data - Inline.png    

Data - Inline 2.png

Using Filters

Filters allow you to refine and segment your data. Analytics by Liaison includes a list of standard filters which may vary by report and may be accompanied by additional report-specific filters, where applicable. By default, multi-select filters (i.e., where multiple values can be active at a time) are set to include all available values for your organization, and single-select filters (i.e., where only one value can be active at a time) are set to a suggested or most logical value given the context of the report. 

Filters 2.png



Mapping to Applicant Portal Field

Application Year 

Application cycle. This filter includes all cycles available from the CAS 3.x platform but does not include cycles from the CAS 2.x platform. 


Citizenship Status

Applicant US Citizenship status.

Applicants complete this question in the Personal Information > Citizenship section of the application: 

Citizenship Question.png

Ethnicity and Race

Applicant race and ethnicity.

Applicants complete this question in the Personal Information > Race & Ethnicity section of the application: 

Ethnicity and Race Question.png


This filter generally includes options for Female, Male, Did not Report, and any CAS-specific custom values that applicants may select in the application (e.g., non-binary). 

Applicants complete this question in the Personal Information > Biographic Information section of the application (note that the question title may vary): 

Example 1:

Gender Question.png

Example 2:

Legal Sex Question.png

Start Term The start term selected by an applicant. N/A
As of Month/Day The As of Month and As of Day filters are used together. When you use these filters, the data is filtered according to the first occurrence of the chosen month and day in each cycle. Note that if a cycle is longer than 365 days, the same month can display more than once in the duration of the cycle.  N/A

Displaying Unknown Values 

Some filters (and even data visualizations) include values that indicate a lack of data. For example, if an applicant withholds information, a filter may include values such as Did not ReportDeclined to StateUnknown, etc. 

Did Not Report 1.png

Selecting Data

You can click on any part of the visualization to isolate it, or use the Ctrl button on a PC (or Command button on a Mac) to select and isolate multiple parts of the visualization:

 Selecting Data 1.png

Additionally, you can use your mouse to click-and-drag to select multiple parts of the visualization (i.e., using a lasso):

Selecting Data 2.png

The data becomes selected when you release the mouse button: 

Selecting Data 3.png

Using Guided Analytics

In some reports, like Demographic Reports, you can isolate a part of a visualization and the data in any other visualizations filter and adjust accordingly. For example, in the Applicant Gender Distribution by Race and Ethnicity report, when you isolate data in the Applicants by Age Group and Gender visualization, the data that appears in the other visualizations corresponds to your initial selection.  

Demographic Isolated Data.png

Once you've selected data, you can use the Tooltip Actions described below. 

Viewing Tooltips 

Tooltips are text or graphical labels that appear when you hover your mouse over or click on an element of a visualization; they contain additional information about the element. For example, in the Applicants by Ethnicity and Race report, when you hover over the grey portion of the visualization, the tooltip provides additional information including the application year, ethnicity and race, percent of total applicants, and an applicant count:

Tooltips 1.png

Some tooltips include embedded visualizations that are particularly useful when there are more than two dimension of interestFor example, in the Applicants by State of Residency report, when you hover over the state of Washington, the tooltip displays a visualization that includes a breakdown of the applicants by application cycle: 

Tooltip 2.png

Using Tooltip Actions

If you select one or more sections of a visualization on a dashboard, the top of the tooltip will expand to include a set of actions you can perform on the data:

Tooltip actions.png

Using tooltip actions, you can:

  • Keep Only the selected data and remove everything else from the view.
  • Exclude the selected data and keep everything else in the view.
  • Sort the data in ascending or descending order (in the example above, you can sort from earliest week to latest week or vice versa).
  • View the data, as described in the next section. 

Viewing Data

Using the View tooltip action, you can view the data for any isolated part of the visualization:

Tooltip actions 1.png

When you click the View button, a new window opens with two tabs:

  1. Summary Tab: this tab displays a summary of only the isolated part of the visualization, which you can download as a text file (it does not include the complete data set):

    Summary Data.png
  2. Full Data: this tab displays the complete data set, which you can download as a text file:

    Full Data.png

    Note: ​​​​​​​when downloading full data, you may wish to select Show all columns to include all data points in the data set.   

    Full Data 2.png

Navigating Maps 

Some reports visualize data through geographic maps. Click on the map to reveal a toolbar that lets you:

  • Search the map or use the button to the right of the search box to focus on current location. 
  • Zoom in and zoom out.  
  • Use the Home button to revert to the map’s default view (note: this does not clear any filters).

Click the toolbar arrow to view additional tools that allow you to:

  • Magnify areas of the map. 
  • Drag the map to obtain a different view. For example, you can drag a world map so that North and South America are on the left side of the screen and Europe is on the right, or a you can drag North and South America to the right so that Asia and Australia are on the left.
  • Use shapes to quickly select geographic regions. 

Map Navigation.png

  • Was this article helpful?