{"id":135,"date":"2023-10-31T11:54:41","date_gmt":"2023-10-31T18:54:41","guid":{"rendered":"https:\/\/sarahpallett.com\/?p=135"},"modified":"2023-10-31T11:54:44","modified_gmt":"2023-10-31T18:54:44","slug":"tableau-tip-add-comments-to-your-calculations","status":"publish","type":"post","link":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/","title":{"rendered":"Tableau Tip: Add Comments to your Calculations"},"content":{"rendered":"\n<p>Recently I inherited a workbook that was a joy to work with \u2013 why, you ask? The developer added comments to each calculation, thereby providing explanations to the nuances for each metric.&nbsp; What a gift!&nbsp; For today\u2019s Tableau Tip, I will show you three different ways to leverage this technique.<\/p>\n\n\n\n<p><strong>Option 1<\/strong><\/p>\n\n\n\n<p>In the calculation editor dialog box, add comments by starting the line with two forward slashes, as depicted in this screenshot:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"331\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png\" alt=\"\" class=\"wp-image-136\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png 602w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1-300x165.png 300w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1-600x330.png 600w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Option 2<\/strong><\/p>\n\n\n\n<p>The second method is a slight modification of Option 1 and works beautifully when the comment is long &amp; detailed.&nbsp; Simply begin the comment with one forward slash and an asterisk and complete the comment with an asterisk and a forward slash.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"332\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-2.png\" alt=\"\" class=\"wp-image-137\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-2.png 605w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-2-300x165.png 300w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-2-600x329.png 600w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Option 3<\/strong><\/p>\n\n\n\n<p>The third option involves one more step but allows you to view the comments without opening the calculation editor dialog box. To follow this method, click on the calculation in the data pane and utilizing the drop-down menu, select Default Properties, Comment. This opens a dialog box where you can add your comments. Best to keep it brief, as these comments will appear when you hover over the calculated field in the data pane.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"623\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-3.png\" alt=\"\" class=\"wp-image-138\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-3.png 601w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-3-289x300.png 289w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"562\" height=\"346\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-4.png\" alt=\"\" class=\"wp-image-139\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-4.png 562w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-4-300x185.png 300w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"305\" height=\"133\" src=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-5.png\" alt=\"\" class=\"wp-image-140\" srcset=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-5.png 305w, https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-5-300x131.png 300w\" sizes=\"auto, (max-width: 305px) 100vw, 305px\" \/><\/figure>\n\n\n\n<p>   <\/p>\n\n\n\n<p>Voil\u00e0! Three easy ways to add notes to help yourself and others when revisions to a workbook are needed (as they often-times are!)  <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Happy Vizzing, folks! <\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently I inherited a workbook that was a joy to work with \u2013 why, you ask? The developer added comments to each calculation, thereby providing explanations to the nuances for each metric.&nbsp; What a gift!&nbsp; For today\u2019s Tableau Tip, I will show you three different ways to leverage this technique. Option 1 In the calculation&#8230; <a class=\"more-link\" href=\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#more-135\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[15,4,3,16],"class_list":["post-135","post","type-post","status-publish","format-standard","hentry","category-data-viz-my-favourite-tips","tag-datafam","tag-dataviz","tag-tableau","tag-tableautip","clear"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tableau Tip: Add Comments to your Calculations - Sarah Pallett<\/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:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau Tip: Add Comments to your Calculations - Sarah Pallett\" \/>\n<meta property=\"og:description\" content=\"Recently I inherited a workbook that was a joy to work with \u2013 why, you ask? The developer added comments to each calculation, thereby providing explanations to the nuances for each metric.&nbsp; What a gift!&nbsp; For today\u2019s Tableau Tip, I will show you three different ways to leverage this technique. Option 1 In the calculation... Continue Reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/\" \/>\n<meta property=\"og:site_name\" content=\"Sarah Pallett\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-31T18:54:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-31T18:54:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png\" \/>\n<meta name=\"author\" content=\"Sarah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sarah\" \/>\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:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/\"},\"author\":{\"name\":\"Sarah\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"headline\":\"Tableau Tip: Add Comments to your Calculations\",\"datePublished\":\"2023-10-31T18:54:41+00:00\",\"dateModified\":\"2023-10-31T18:54:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/\"},\"wordCount\":225,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png\",\"keywords\":[\"DataFam\",\"DataViz\",\"Tableau\",\"TableauTip\"],\"articleSection\":[\"Data Viz - My Favourite Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/\",\"url\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/\",\"name\":\"Tableau Tip: Add Comments to your Calculations - Sarah Pallett\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png\",\"datePublished\":\"2023-10-31T18:54:41+00:00\",\"dateModified\":\"2023-10-31T18:54:44+00:00\",\"author\":{\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"breadcrumb\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage\",\"url\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png\",\"contentUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png\",\"width\":602,\"height\":331},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sarahpallett.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tableau Tip: Add Comments to your Calculations\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sarahpallett.com\/#website\",\"url\":\"https:\/\/sarahpallett.com\/\",\"name\":\"Sarah Pallett\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sarahpallett.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\",\"name\":\"Sarah\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"caption\":\"Sarah\"},\"sameAs\":[\"https:\/\/sarahpallett.com\/wp\"],\"url\":\"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tableau Tip: Add Comments to your Calculations - Sarah Pallett","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:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/","og_locale":"en_US","og_type":"article","og_title":"Tableau Tip: Add Comments to your Calculations - Sarah Pallett","og_description":"Recently I inherited a workbook that was a joy to work with \u2013 why, you ask? The developer added comments to each calculation, thereby providing explanations to the nuances for each metric.&nbsp; What a gift!&nbsp; For today\u2019s Tableau Tip, I will show you three different ways to leverage this technique. Option 1 In the calculation... Continue Reading &rarr;","og_url":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/","og_site_name":"Sarah Pallett","article_published_time":"2023-10-31T18:54:41+00:00","article_modified_time":"2023-10-31T18:54:44+00:00","og_image":[{"url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png","type":"","width":"","height":""}],"author":"Sarah","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sarah","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#article","isPartOf":{"@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/"},"author":{"name":"Sarah","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"headline":"Tableau Tip: Add Comments to your Calculations","datePublished":"2023-10-31T18:54:41+00:00","dateModified":"2023-10-31T18:54:44+00:00","mainEntityOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/"},"wordCount":225,"commentCount":0,"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png","keywords":["DataFam","DataViz","Tableau","TableauTip"],"articleSection":["Data Viz - My Favourite Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/","url":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/","name":"Tableau Tip: Add Comments to your Calculations - Sarah Pallett","isPartOf":{"@id":"https:\/\/sarahpallett.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage"},"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png","datePublished":"2023-10-31T18:54:41+00:00","dateModified":"2023-10-31T18:54:44+00:00","author":{"@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"breadcrumb":{"@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#primaryimage","url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png","contentUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2023\/10\/Screenshot-comments-1.png","width":602,"height":331},{"@type":"BreadcrumbList","@id":"https:\/\/sarahpallett.com\/index.php\/2023\/10\/31\/tableau-tip-add-comments-to-your-calculations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sarahpallett.com\/"},{"@type":"ListItem","position":2,"name":"Tableau Tip: Add Comments to your Calculations"}]},{"@type":"WebSite","@id":"https:\/\/sarahpallett.com\/#website","url":"https:\/\/sarahpallett.com\/","name":"Sarah Pallett","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sarahpallett.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8","name":"Sarah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","caption":"Sarah"},"sameAs":["https:\/\/sarahpallett.com\/wp"],"url":"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":4,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":144,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions\/144"}],"wp:attachment":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/media?parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/categories?post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/tags?post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}