Analysis Across Tests: Pivot Table

Analysis Across Tests: Pivot Table

Overview 

Did you know that you can run data splits analysis in Compusense!? We have a built in report, called Consumer report, that enables you to split the data based on the:
  1. Panelist demographic information collected within the test or stored in the Panelists library.
  2. Sample first position.
If this report does not meet all your analysis needs, we also have the Pivot table option in the Advanced search & analysis across tests area, which we are describing in more detail on this page.


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. ...