Go to Otus
All Collections
Administrators
Reports
Reports: Analyzing a Query

Reports: Analyzing a Query

This article will show you how to analyze a Query you've generated.
Monica Burke avatar
Written by Monica Burke. Updated over a week ago

Once you generate a Query, you are presented with data in many forms, from pie charts to bar graphs to tables. Let's take a closer look at each section of the Query.

Article Table of Contents:

➡️ This article describes how to analyze a query. For instructions on how to build, clone, send a copy, edit, or delete a query, scroll to the bottom and check out the links for Next Steps.

Analyzing a Query

➡️ Summary Pie Charts

  • At the top of the query will be four summary pie charts for sites (schools), grade level, ethnicity/race, and gender.

  • As you hover over any section of any pie chart, you will see a summary of that section indicating the number of students and what percentage that section represents.

➡️ Summary Bar Graphs

  • The next section contains summary bar graphs for student groups, teacher groups, and classes.

❗ How is it determined which groups and classes show? The selections are based on population. The query will display the 10 student groups, teacher groups, and classes with the highest populations based on the results of this query.

  • As you hover over any section of any bar graph, you will see the number of students in that section.

➡️ Individual Student Data Table

  • 1 - Student Groups: You can create or add students to student groups using the Flag icon. Select the students you wish to add to a group, then select the Flag icon.

  • 2 - Sorting: You can sort any column by selecting its header.

  • 3 - Download: Download this table into an excel spreadsheet

  • 4 - Change View: You can change your view to see 10, 25, or 50 student at a time.

  • 5 - Pages: Click from page to page to continue the list of students.

➡️ Did you use Matrix Values in the Query?

Continue reading below to learn more about how to analyze the data with those Matrix Values.

  • When the report generates, the table will include columns for the matrix values.

  • You will see that the matrix values are given to the students that qualify for that particular criteria. The very last column will total all of the values the student was given.

➡️ Using the Filters

  • Selecting any filters from the left will further narrow down the results of the query. You will notice the pie charts, bar graphs, and table change as you select and deselect filters.

❗ How is it determined which options you are presented with for each filter

  • Filters that remain static from query to query are Grade Level, Ethnicity/Race, and Gender. Those three filters will have the same options each time you run a query.

  • The filters that will fluctuate based on the results of the query will be Student Groups, Teacher Groups, and Classes. These filters will have the 10 options based on highest population; the groups and classes with the highest number of students generated by this query will be listed here.

FAQ

  • How often is data synced to Query? Monday-Thursday at 8:00 pm CST

  • Is there a limit to the number of classes that appear in the results of a query? Yes - 10 classes.

  • Is there a limit to the number of students that can fit the criteria in your query? Yes - 1,000 students - Queries that contain more than 1,000 students will not complete.

  • Do changes to class names reflect automatically? No, they require the nightly sync to update in query.

Next Steps

Building a Query
Edit or Delete a Query
Cloning a Query
Sending a Copy of a Query
Did this answer your question?