When you want to view how applicants compare to their peers, you are able to use a cluster report that is viewed within the Slate Reader. Many times, the comparison is done among applicants who are attending the same school, often containing GPA, class rank, and test score information. There is a cluster report that can be added via Suitcase that you can use to get started. Please note, there is a separate article about displaying the cluster report within the Reader available here.

Add the Cluster Report via Suitcase

1. Click Database in the top navigation bar and select Suitcase.

2. Click Import. A pop-up appears.

3. In the text field, paste the following Suitcase ID:
   c1de33a4-7cfa-46f1-a312-78a4e70be5d5:slate-examples

4. Click Retrieve. 

5. Click Queries / Reports in the top navigation bar.

6. Select the Cluster Report query under the Reader-Reports folder.

7. Open the Cluster Report.

8. Open the Cluster Report.

Customizing the Cluster Report Query

Important!

Do not remove the Students at Current Applicant's School #1 filter. This filter is what will allow the Reader to display the results for just the applicants who attended the same school as the current applicant.

You are able to customize the query to include any data points that you want displayed. You are also able to adjust the title, orientation, and set the widths for each data point.

1. Remove unwanted data points from the query.

2. Add additional data points that you would like to include.

3. Double click on each export to customize the settings.

   • The Name of the export will appear as the column header in the cluster report.

   • The same configuration options that you are able to use in normal queries are available in cluster reports, including the ability to configure export values and translation codes.

   • Drag the exports to reorder them.

   • Add additional filters to further restrict the population, if desired. For example, you may wish to only show other current applicants using the 'Application Period Active' filter.

   • Add, remove, update, or re-order the Sort Keys. With the Sort Keys below, the order will first be determined by the Round (in ascending order), then the Application Status (in ascending order), followed by the applicant's Name (in ascending order). Each Sort Key after the first is used only in the case of a tie. This means that two applications in the 2017 EA Round will then be ordered based on their Application Status (if the statuses are different), and in the case of a tie, the Name will be used to determine the order.

Testing the Query

The Students at Current Applicant's School #1 filter relies on a parameter value in order to filter results. Values for parameters can be passed to the query at the time it runs. Since the parameter value will determine the results of the query, the Estimated Rows functionality is not available.

The cluster report uses the Person GUID (a 36-character unique ID) that the Reader automatically passes to it as the @person parameter.  The @person parameter is defined in the Edit Web Service popup, and it should not be changed.

• In order to test the query, you must provide it with a parameter value to use. On the landing page for the cluster report, you are able to enter the parameter value before clicking the Run Query button.

• You are able to find the Person GUID for any record by navigating to the Dashboard tab of that record. The last portion of the URL in the address bar is the Person GUID. For example: https://slate-demo.technolutions.net/manage/lookup-duo/record?id=6bb2c3fd-218f-452b-a435-838babc7b01d

• Copy the Person GUID of the record with which you would like to test the query, paste it into the @person parameter box, and then click Run Query.

On the Query Results page, confirm that the values you want displayed on the cluster report are appearing in the desired format and order. Make any adjustments to the query until you are seeing the results as you want them to appear. 

Edit the Report Options

All queries in the Reader-Reports folder have an additional action button Edit Report Options.

The Report Options that can be adjusted include: 

Since you will have to make some adjustments once you see the report within the Reader, it is recommended that you leave the Column Widths blank for now. Once you see how the data appears by default, you will be able to make more educated adjustments to the Column Widths.

For continued reading, you can learn how to display the cluster report within the Reader here.