{"id":52786,"date":"2020-12-19T10:36:13","date_gmt":"2020-12-19T10:36:13","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=52786"},"modified":"2022-08-04T09:44:51","modified_gmt":"2022-08-04T09:44:51","slug":"how-to-add-cross-tabs-to-your-report","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/","title":{"rendered":"Cross Tabs in Omni"},"content":{"rendered":"<p>A Cross Tab is used to investigate potential relationships in responses to two or three close-ended questions. Like Score, Cross Tabs can be calculated and added to your Omni Report to make it easy to review &#8212; and share \u2013 a lot of information in a conveniently consolidated format.<\/p>\n<p class=\"sogo-help-sub-head\">Navigate to<\/p> \r\n\r\n  \r\n\r\n<ul class=\"sogo-help-sub-list\"> \r\n\r\n <li><a href=\"#section-1\">Creating a Cross Tab in Omni <\/a><\/li> \r\n\r\n<li><a href=\"#section-2\"> Customize your Cross Tab <\/a><\/li> \r\n\r\n\r\n<\/ul> \n<h2 id=\"section-1\">Creating a Cross Tab in Omni<\/h2>\n<p>To create and add a Cross Tab within an Omni Report, you\u2019ll need to choose the rows and columns of questions and Cell Values to be displayed. Review these options below.<\/p>\n<h3>Adding questions to your Cross Tab<\/h3>\n<ol>\n<li>Select your project, then click on Report to view the Omni Report.<\/li>\n<li>Click the Cross Tab icon at the top of the report.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT18.png\"><\/li>\n<li>Here, provide a description for the Cross Tab that will be displayed on the report and select its position in the report. By default, the Cross Tab will be placed in the beginning of the report, but you can change this from the dropdown menu.<\/li>\n<li>Configure the Cross Tab by dragging and dropping questions or metadata elements into Rows and Columns.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT19.gif\"><\/li>\n<li>Choose to include multiple questions in either Rows OR Columns, or both Rows and Columns.<\/li>\n<\/ol>\n<h3>Defining Cell Values<\/h3>\n<ol>\n<li>Once you have added questions to your rows or columns, define the cell values you\u2019d like to display.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT20.png\"><\/li>\n<li>In addition to count, the following cell values will be available based on the questions you have added to the rows and columns:<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT21.png\"><\/p>\n<ol style=\"list-style: lower-alpha;\">\n<li>% in Row<\/li>\n<li>% in Column<\/li>\n<li><strong>For Numeric Questions:\u200b<\/strong>\n<ul>\n<li>Sum<\/li>\n<li>Average<\/li>\n<li>Mode<\/li>\n<li>Median<\/li>\n<li>Minimum<\/li>\n<li>Maximum<\/li>\n<li>Standard Deviation<\/li>\n<\/ul>\n<\/li>\n<li><strong>For Rating Questions:\u200b <\/strong>\n<ul>\n<li>Weighted Score<\/li>\n<li>Weighted Score as percentage<\/li>\n<li>Net Score \u200b<\/li>\n<li>Percent Favorable\u200b<\/li>\n<\/ul>\n<li><strong>For Metric Questions:\u200b<\/strong>\n<ul>\n<li>NPS<\/li>\n<li>CSAT<\/li>\n<li>CES <\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Based on the Cell Value selected, you\u2019ll see the questions being displayed in the corresponding dropdown. Select the desired question or metadata element from the dropdown to display as the Cell Values in your Cross Tab.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT22.png\"><\/li>\n<li>You may customize the label name, such as \u2018Overall Satisfaction\u2019.<\/li>\n<li>Add or delete the Cell Values from the options beside it.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT23.png\"><\/li>\n<li> If you choose to have questions in both Rows and Columns, then you have an option to view Cell Values in Rows or Columns.<\/li>\n<li> Click Save to view your Cross Tab.<\/li>\n<\/ol>\n<h2 id=\"section-2\">Customize your Cross Tab<\/h2>\n<ol>\n<li>To add the Cross Tab in your Omni Report to your Canvas, hover over the Cross Tab and click Add to Canvas.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT24.png\"><\/li>\n<li>Further customize your Cross Tab by clicking on the three-dot menu, next to row\/column question text.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT25.png\"><\/p>\n<ul>\n<li><strong>Edit Label:<\/strong> Allows you to edit the question text<\/li>\n<li><strong>Answer Options:<\/strong> Allows you to exclude or merge answers<\/li>\n<li><strong>Remove Total:<\/strong> Allows you to remove the total row\/column for the question<\/li>\n<li><strong>Remove Did Not Answer:<\/strong> Allows you to remove the Did Not Answer row\/column<\/li>\n<\/ul>\n<\/li>\n<li>For more Cross Tab options, hover and click on three-dot menu next to description.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT27.png\"><\/li>\n<ul>\n<li><strong>Edit:<\/strong> Takes you to the configuration steps. Add or modify questions or Cell Values here.<\/li>\n<li><strong>Conditional Formatting:<\/strong> Allows you to format the Cross Tab cells based on their value. In the Conditional Formatting modal, select the Condition and specify value and the color for the cells. This option can be used to present a heat map report display.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT28.png\"><\/li>\n<li><strong>Apply Filter: <\/strong>Further drill down your Cross Tab by filtering.<br \/>\n<img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/2021\/10\/PT29.png\"><\/li>\n<li><strong>Remove: <\/strong><\/li>\n<p>This will remove Cross Tab from the report.<\/ul>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>A Cross Tab is used to investigate potential relationships in responses to two or three close-ended questions. Like Score, Cross Tabs can be calculated and added to your Omni Report to make it easy to review &#8212; and share \u2013 a lot of information in a conveniently consolidated format. Creating a Cross Tab in Omni To create and add a Cross Tab within an Omni Report, you\u2019ll need to choose the rows and columns of questions and Cell Values to be displayed. Review these options below. Adding questions to your Cross Tab Select your project, then click on Report to view the Omni Report. Click the Cross Tab icon at the top of the report. Here, provide a description for the Cross Tab that will be displayed on the report and select its position in the report. By default, the Cross Tab will be placed in the beginning of the report, but you can change this from the dropdown menu. Configure the Cross Tab by dragging and dropping questions or metadata elements into Rows and Columns. Choose to include multiple questions in either Rows OR Columns, or both Rows and Columns. Defining Cell Values Once you have added questions to your rows or columns, define the cell values you\u2019d like to display. In addition to count, the following cell values will be available based on the questions you have added to the rows and columns: % in Row % in Column For Numeric Questions:\u200b Sum Average Mode Median Minimum Maximum [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":0,"parent":0,"menu_order":510,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"footnotes":""},"categories":[230],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.7.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Add Cross Tabs to Omni Report | Sogolytics<\/title>\n<meta name=\"description\" content=\"Add a Cross Tab to the Omni Report to quickly drill down on potential relationships between key variables at a glance with heat map options.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Add Cross Tabs to Omni Report | Sogolytics\" \/>\n<meta property=\"og:description\" content=\"Add a Cross Tab to the Omni Report to quickly drill down on potential relationships between key variables at a glance with heat map options.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-04T09:44:51+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/\",\"url\":\"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/\",\"name\":\"How to Add Cross Tabs to Omni Report | Sogolytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\"},\"datePublished\":\"2020-12-19T10:36:13+00:00\",\"dateModified\":\"2022-08-04T09:44:51+00:00\",\"description\":\"Add a Cross Tab to the Omni Report to quickly drill down on potential relationships between key variables at a glance with heat map options.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sogolytics.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cross Tabs in Omni\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\",\"url\":\"https:\/\/www.sogolytics.com\/help\/\",\"name\":\"Sogolytics\",\"description\":\"Sogolytics - Online Survey Tool\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Add Cross Tabs to Omni Report | Sogolytics","description":"Add a Cross Tab to the Omni Report to quickly drill down on potential relationships between key variables at a glance with heat map options.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/","og_locale":"en_US","og_type":"article","og_title":"How to Add Cross Tabs to Omni Report | Sogolytics","og_description":"Add a Cross Tab to the Omni Report to quickly drill down on potential relationships between key variables at a glance with heat map options.","og_url":"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/","og_site_name":"Sogolytics","article_modified_time":"2022-08-04T09:44:51+00:00","twitter_card":"summary","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/","url":"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/","name":"How to Add Cross Tabs to Omni Report | Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2020-12-19T10:36:13+00:00","dateModified":"2022-08-04T09:44:51+00:00","description":"Add a Cross Tab to the Omni Report to quickly drill down on potential relationships between key variables at a glance with heat map options.","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/how-to-add-cross-tabs-to-your-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Cross Tabs in Omni"}]},{"@type":"WebSite","@id":"https:\/\/www.sogolytics.com\/help\/#website","url":"https:\/\/www.sogolytics.com\/help\/","name":"Sogolytics","description":"Sogolytics - Online Survey Tool","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"seo_meta_info":{"yoast_noindex":"","rankmath_noindex":"","yoast_title":"How to Add Cross Tabs to Omni Report | Sogolytics","yoast_desc":"Add a Cross Tab to the Omni Report to quickly drill down on potential relationships between key variables at a glance with heat map options.","rankmath_title":"Cross Tabs in Omni","rankmath_desc":"A Cross Tab is used to investigate potential relationships in responses to two or three close-ended questions. Like Score, Cross Tabs can be calculated and&hellip;"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/52786"}],"collection":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/comments?post=52786"}],"version-history":[{"count":12,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/52786\/revisions"}],"predecessor-version":[{"id":59326,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/52786\/revisions\/59326"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=52786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=52786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=52786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}