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. If you have any ...
    • 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: 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 ...
    • Descriptive Analysis Workbook Correlation Table

      What is it? Correlation Table is one of the sheets in the Descriptive Analysis Workbook . Displays the attribute correlation across all samples and reps. Why would I use it? To see if there is a positive or negative correlation between attributes. ...
    • Descriptive Analysis Workbook Panelist SD Table

      What is it? Panelist SD Table is one of the sheets in the Descriptive Analysis Workbook . A table with the Square root of Mean Square Error (Sqrt(MSE)) value by attribute and the Standard Deviation (SD) from a 1-way ANOVA by panelist and attribute. ...