Symphony Statistics View
Top

Introduction

Symphony's Statistics view enables you to define and run queries against your project. Queries consist of:

Symphony's Statistics view is quite powerful and quick. It makes it possible for you to ask pretty much anything of your data and get an almost immediate response. If your project includes demographics or ratings items defined as demographics, you should find that Symphony's Statistics view provides you with the tools you need to gain deep insights into your data.

Define a query

  1. Click the New Query button on the toolbar directly above the Queries List.
  2. In the Query Properties form, give the query a name. The name can be whatever you want it to be, but be aware that if you output the query to Excel, the name will be modified to conform to the worksheet naming limitations.
  3. Optionally provide a description to remind you what the query does.
  4. Click OK. the query will appear in the Queries list
  5. Click the query in the Queries list so it is highlighted.
  6. Click the checkbox next to each column you want to add to the query. As you do this, columns will appear in the Results panel at the bottom of the view.
  7. If you decide to remove a column, uncheck its box or click the "close button" on the row header and it will be removed.
  8. Repeat until all the columns you want in the query appear in the Results panel.

Run a query

  1. Click the Query you want to run in the Queries list. Its columns will appear in the Results panel
  2. Click the Run button () button on the view's toolbar. The results will appear in the Results panel.

Download Query Results to Excel

  1. Run the query you want to download.
  2. After the query finishes, click the Download Excel () button.
  3. Follow your browser's instructions for saving the file to your computer
The Download Excel button always downloads the results of the last query you ran. So if you run two queries and want to download the first one, you must run it again, or you will get the results of the last query.

Delete a Query

If you decide to delete a query you defined, highlight it in the Queries list and click the Delete () button directly above the list.

Predefined Queries

In addition to the queries you define, Symphony also creates four queries in every project. These queries can be modified, but they cannot be deleted. Here's what they each do by default:

Available Columns

Statistics View includes three lists of columns that can be added to queries. This section describes each.

Entity Columns

Entity Columns represent the content in your project such as codes, tags, respondents, and so forth. Entities normally have relationships with other entities -- often many relationships. For example, a code has a relationship with all the codes and comments inside of it. When an entity column is included in a query, it effectively function as a row-level filter. What this means is that a row is output for each entity. If mutiple entity columns are included in a query, a row is output for each combination of entities.

Project Member

Outputs the name of each Symphony user with access to your project. As a minimum it includes you but can include other users if you have a shared account and you give them access.

Respondents

Outputs the name of each survey respondent or interviewee for your project Respondents are the entities to whom comments are attributed to.

Code Level 1, Code Level 2, etc.

TOutput the your codes at the respective levels.

Demographics

If you have any demographics defined, they are listed next. Including one of them outputs the values of each of the demographic values. For example, a Gender demographic might output two rows: one for Male and one for Female.

Tag Groups

Outputs a row for each Tag Group in your project. Tag Groups include demographics because demographics are set up as a special kind of Tag Group.

Tags

Outputs the Tags contained inside your Tag Groups.

Word/Phrase

Output each word/phrase found in the project.

A key to understanding how to get what you want from a query is grasping the fact that when more than one entity column is included, an output row is created for each combination of values. For example if your project has demographics for Occupation and Gender, you will get a row for each Occupation/Gender pair if you include them both in a query. This effectively gives you the capability to create drill-downs into any slice of your project.

Statistic Columns

Statistic Columns produce numbers for you. They can be used by themselves, but when they are combined with one or more entity columns, a row is produced for each entity combination and the statistic is based on the entity.

# of Respondents

A count of respondents.

# of Comments

A count of comments.

# of Words

A count of words.

Phrase Count

A count of how many times a word/phrase appears. This is used in conjuction with the Word/Phrase column from the Entities list.

Avg # of Words

Average # of words found in the underlying comments for each row. If no enties or attribute columns are included in the query, this is the average # of words found in all the comments in the project.