{"id":67,"date":"2011-09-06T10:05:21","date_gmt":"2011-09-06T15:05:21","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2011\/09\/cross-tab-views\/"},"modified":"2015-10-26T13:40:11","modified_gmt":"2015-10-26T18:40:11","slug":"cross-tab-views","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/","title":{"rendered":"Cross tab views"},"content":{"rendered":"<p><a href=\"http:\/\/www.teamdesk.net\">TeamDesk<\/a> holds the data in flat tables meaning that it consist from fixed number of columns and variable number of rows. While such structure can contain a lot of information it can be difficult to present summarized info in such a way.<\/p>\n<p>Let&#8217;s demonstrate typical Task Management application. We have a project to work on, a person to perform the task, a date the task is performed and a amount of time spent on the task:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-440 aligncenter\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png\" alt=\"44,1\" width=\"449\" height=\"202\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png 449w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441-300x135.png 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/a><\/p>\n<p>Now we need to find an answer: how much time the team spent each day on each project. Obviously you can obtain the results using summary views:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/442.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-441\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/442.png\" alt=\"44,2\" width=\"441\" height=\"202\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/442.png 441w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/442-300x137.png 300w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/a><\/p>\n<p>Obviously, the answer is found, but you&#8217;d likely want to have subtotals for all projects each day as well as subtotal by the project for the whole time period.<\/p>\n<p>With charts you would be closer to the goal \u2013 you&#8217;ll have approximate subtotals by day, but you won&#8217;t get precise value. For example, for 06\/09\/2001 is a total 18 or 19?<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/443.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-442\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/443.gif\" alt=\"44,3\" width=\"480\" height=\"340\" \/><\/a><\/p>\n<p>Also, charts are limited to calculate single value. So, cross tabs will bridge the gap between summary and chart views.<\/p>\n<p>For a cross tab you&#8217;ll need to specify the field whose values will form columns in an output and another field whose values will form rows; and then the field(s) and function to calculate to form a value of a cell on an intersection of row and column. In our example projects will form columns while dates will form rows; each cell displays the number of tasks and total time spent.<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/444.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-443\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/444.png\" alt=\"44,4\" width=\"500\" height=\"157\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/444.png 500w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/444-300x94.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Rows, columns and cells are clickable. Clicking on a column heading will display records by specific project for all dates. Clicking the date will display records by specific date for all project. And clicking the cell will display records by specific date and project:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/445.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-445\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/445.png\" alt=\"44,5\" width=\"398\" height=\"326\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/445.png 398w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/445-300x246.png 300w\" sizes=\"auto, (max-width: 398px) 100vw, 398px\" \/><\/a><\/p>\n<p>We hope cross tab views will add the value to TeamDesk toolset.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TeamDesk holds the data in flat tables meaning that it consist from fixed number of columns and variable number of rows. While such structure can contain a lot of information it can be difficult to present summarized info in such a way. Let&#8217;s demonstrate typical Task Management application. We have a project to work on, [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-whats-new"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cross tab views - TeamDesk Blog<\/title>\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.teamdesk.net\/blog\/whats-new\/cross-tab-views\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cross tab views - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"TeamDesk holds the data in flat tables meaning that it consist from fixed number of columns and variable number of rows. While such structure can contain a lot of information it can be difficult to present summarized info in such a way. Let&#8217;s demonstrate typical Task Management application. We have a project to work on, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-06T15:05:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-10-26T18:40:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png\" \/>\n<meta name=\"author\" content=\"Kirill Bondar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirill Bondar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"Cross tab views\",\"datePublished\":\"2011-09-06T15:05:21+00:00\",\"dateModified\":\"2015-10-26T18:40:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/\"},\"wordCount\":311,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/09\\\/441.png\",\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/\",\"name\":\"Cross tab views - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/09\\\/441.png\",\"datePublished\":\"2011-09-06T15:05:21+00:00\",\"dateModified\":\"2015-10-26T18:40:11+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/09\\\/441.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/09\\\/441.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/cross-tab-views\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cross tab views\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\",\"name\":\"Kirill Bondar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"caption\":\"Kirill Bondar\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/kirill-bondar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cross tab views - TeamDesk Blog","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.teamdesk.net\/blog\/whats-new\/cross-tab-views\/","og_locale":"en_US","og_type":"article","og_title":"Cross tab views - TeamDesk Blog","og_description":"TeamDesk holds the data in flat tables meaning that it consist from fixed number of columns and variable number of rows. While such structure can contain a lot of information it can be difficult to present summarized info in such a way. Let&#8217;s demonstrate typical Task Management application. We have a project to work on, [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/","og_site_name":"TeamDesk Blog","article_published_time":"2011-09-06T15:05:21+00:00","article_modified_time":"2015-10-26T18:40:11+00:00","og_image":[{"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png","type":"","width":"","height":""}],"author":"Kirill Bondar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirill Bondar","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"Cross tab views","datePublished":"2011-09-06T15:05:21+00:00","dateModified":"2015-10-26T18:40:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/"},"wordCount":311,"commentCount":1,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png","articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/","name":"Cross tab views - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png","datePublished":"2011-09-06T15:05:21+00:00","dateModified":"2015-10-26T18:40:11+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2011\/09\/441.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/cross-tab-views\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Cross tab views"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2","name":"Kirill Bondar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","caption":"Kirill Bondar"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/kirill-bondar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":2,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":446,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions\/446"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}