Analysis Across Tests: Pivot Table

Analysis Across Tests: Pivot Table

Overview 

The Pivot table feature enables you to review descriptive statistics of data sets from multiple compatible tests in a live and interactive way. The data transformations are immediate and the table can be exported as an Excel workbook or a .csv file.


NotesWe also have a built in Consumer report that enables you to split the data from compatible tests based on panelist demographic information and/or sample first position.


Test Compatibility

The Pivot table feature is compatible with:
  1. Survey test type. The exception is the Rank concepts data in these tests; it is not compatible with the Pivot table.

  2. Most Standard tests. The exceptions are those that have Projective mapping, or Ranking, or Temporal data in them.

The Pivot table feature is not compatible with any Discrimination test types.


Generate The Pivot Table 

  1. In the Advanced search & analysis across tests area, search for the test or tests you wish to generate the pivot table on.


  2. Select the test(s) you wish to analyze and click Pivot table.


  3. In the Pivot table area, there are several options you can modify to suit your reporting needs: 

  1. Set the Values, Columns, and Rows in your table by updating the default selections, by removing them, or by clicking on the corresponding plus (+) symbol to display additional details.

  2. Click Hide settings to expand the table and hide the settings out of the view. Click Show settings to revert to the default table view with settings included.

  3. Click Export and select between the .xlsx and .csv file formats for your Pivot table export. The file will save to your browser's default downloads folder.