{"id":532,"date":"2021-05-22T12:31:39","date_gmt":"2021-05-22T12:31:39","guid":{"rendered":"https:\/\/support.zippydoc.de\/?p=532"},"modified":"2022-04-23T08:36:56","modified_gmt":"2022-04-23T08:36:56","slug":"crosstab","status":"publish","type":"post","link":"https:\/\/support.zippydoc.de\/en\/crosstab\/","title":{"rendered":"Crosstab"},"content":{"rendered":"

What is the \u2018Crosstab\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.<\/p>\n

 <\/p>\n

 <\/p>\n

How to use the \u2018Crosstab\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

 <\/p>\n

The important fields in the \u2018Crosstab\u2019 task are<\/p>\n

    \n
  1. Select Table<\/strong><\/li>\n<\/ol>\n

    Use this dropdown menu to select the table which you would like to analyse.<\/p>\n

     <\/p>\n

      \n
    1. Group Data by These Values<\/strong><\/li>\n<\/ol>\n

      Use this dropdown menu to select the columns from the input table which you would like to send to grouped rows in the output table. These will become the row headings in the output table.<\/p>\n

       <\/p>\n

        \n
      1. Change Column Headers<\/strong><\/li>\n<\/ol>\n

        Use this dropdown menu to select the column from the input table which you would like to send to column in the output table. These will become the column headings in the output table.<\/p>\n

         <\/p>\n

          \n
        1. Values for New Columns<\/strong><\/li>\n<\/ol>\n

          Use this dropdown menu to select the columns from the input table which you would like to summarise. The text or numerical calculation will apply to this selection.<\/p>\n

           <\/p>\n

            \n
          1. Method for Aggregating Values<\/strong><\/li>\n<\/ol>\n

            Use this dropdown menu to select the type of calculation you would like to apply to selected \u2018Value for New Columns\u2019. This can be a numerical or text calculation or a user-defined static value.<\/p>\n

             <\/p>\n

             <\/p>\n

            How to use the \u2018Define Output Table\u2019 and the \u2018Output Options\u2019 sections in the \u2018Crosstab\u2019 task?<\/strong><\/p>\n

            The \u2018Output Options\u2019 section in the \u2018Crosstab\u2019 task can be used to modify features of the output table. The fields related to this section become visible on selecting the \u2018Output Options\u2019 checkbox.<\/p>\n

            More information about this section is available here<\/a><\/strong><\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"

            The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[157],"tags":[182,184,183,33],"featured_image_src":{"landsacpe":false,"list":false,"medium":false,"full":false},"yoast_head":"\nCrosstab - Zippydoc Support<\/title>\n<meta name=\"description\" content=\"The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.zippydoc.de\/en\/crosstab\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Crosstab - Zippydoc Support\" \/>\n<meta property=\"og:description\" content=\"The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.zippydoc.de\/en\/crosstab\/\" \/>\n<meta property=\"og:site_name\" content=\"Zippydoc Support\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-22T12:31:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-23T08:36:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Crosstab-Pictogram-e1621710096980.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tejas Valake\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#website\",\"url\":\"https:\/\/support.zippydoc.de\/en\/\",\"name\":\"Zippydoc Support\",\"description\":\"Connect as if by magic\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.zippydoc.de\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/crosstab\/#primaryimage\",\"url\":\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Crosstab-Pictogram-e1621710096980.png\",\"contentUrl\":\"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Crosstab-Pictogram-e1621710096980.png\",\"width\":744,\"height\":150},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/crosstab\/#webpage\",\"url\":\"https:\/\/support.zippydoc.de\/en\/crosstab\/\",\"name\":\"Crosstab - Zippydoc Support\",\"isPartOf\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/crosstab\/#primaryimage\"},\"datePublished\":\"2021-05-22T12:31:39+00:00\",\"dateModified\":\"2022-04-23T08:36:56+00:00\",\"author\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946\"},\"description\":\"The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.\",\"breadcrumb\":{\"@id\":\"https:\/\/support.zippydoc.de\/en\/crosstab\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.zippydoc.de\/en\/crosstab\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/crosstab\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.zippydoc.de\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Crosstab\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946\",\"name\":\"Tejas Valake\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g\",\"caption\":\"Tejas Valake\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Crosstab - Zippydoc Support","description":"The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.","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:\/\/support.zippydoc.de\/en\/crosstab\/","og_locale":"en_US","og_type":"article","og_title":"Crosstab - Zippydoc Support","og_description":"The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.","og_url":"https:\/\/support.zippydoc.de\/en\/crosstab\/","og_site_name":"Zippydoc Support","article_published_time":"2021-05-22T12:31:39+00:00","article_modified_time":"2022-04-23T08:36:56+00:00","og_image":[{"url":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Crosstab-Pictogram-e1621710096980.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tejas Valake","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/support.zippydoc.de\/en\/#website","url":"https:\/\/support.zippydoc.de\/en\/","name":"Zippydoc Support","description":"Connect as if by magic","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.zippydoc.de\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.zippydoc.de\/en\/crosstab\/#primaryimage","url":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Crosstab-Pictogram-e1621710096980.png","contentUrl":"https:\/\/support.zippydoc.de\/wp-content\/uploads\/2021\/05\/v1-TD-Crosstab-Pictogram-e1621710096980.png","width":744,"height":150},{"@type":"WebPage","@id":"https:\/\/support.zippydoc.de\/en\/crosstab\/#webpage","url":"https:\/\/support.zippydoc.de\/en\/crosstab\/","name":"Crosstab - Zippydoc Support","isPartOf":{"@id":"https:\/\/support.zippydoc.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.zippydoc.de\/en\/crosstab\/#primaryimage"},"datePublished":"2021-05-22T12:31:39+00:00","dateModified":"2022-04-23T08:36:56+00:00","author":{"@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946"},"description":"The \u2018Crosstab\u2019 task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.","breadcrumb":{"@id":"https:\/\/support.zippydoc.de\/en\/crosstab\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.zippydoc.de\/en\/crosstab\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/support.zippydoc.de\/en\/crosstab\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.zippydoc.de\/en\/"},{"@type":"ListItem","position":2,"name":"Crosstab"}]},{"@type":"Person","@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/4dd5b174233e1b7f097497d8e2a9e946","name":"Tejas Valake","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.zippydoc.de\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29659872a5889dde06af986e03bd8c12?s=96&d=mm&r=g","caption":"Tejas Valake"}}]}},"_links":{"self":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts\/532"}],"collection":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/comments?post=532"}],"version-history":[{"count":0,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/posts\/532\/revisions"}],"wp:attachment":[{"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/media?parent=532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/categories?post=532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.zippydoc.de\/en\/wp-json\/wp\/v2\/tags?post=532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}