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.



    • Related Articles

    • Advanced Search & Analysis Across Tests

      Overview This quick video will take you through how to use the Advanced search & analysis across tests feature! This feature provides you the flexibly to select multiple test to generate reports, graphs, or pivot tables across them. The analysis ...

    • Analysis Across Tests: ANOVAs

      Overview Analysis of Variance (ANOVA) is available in Compusense across tests and can be accessed in two reports: the Summary report and the PowerPoint (PPT) report. By combining data from multiple tests, the across-tests ANOVA analysis enables you ...

    • Analysis Across Tests: Graphing

      Overview The Graphing tool can provide you with visual representation of your data across multiple sections within a single test or across multiple tests with or without multiple sections in them. Nothing prevents you from generating graphs within a ...

    • Analysis Across Tests: Consumer Report

      Overview The Consumer report can be generated across multiple tests in the Advanced search & analysis across tests area. All options available in the single-test Consumer Report are available here, with one exception: the First position data split is ...

    • Analysis Across Tests: Dunnett's Analysis For Shelf-life Testing Data

      Overview The recommended analysis for shelf-life testing data is the Dunnett's test. Dunnett's test compares a (blind) control against each test sample. This workflow will help you select specific analysis options when generating the PowerPoint ...