{"id":331,"date":"2025-02-27T14:02:52","date_gmt":"2025-02-27T22:02:52","guid":{"rendered":"https:\/\/sarahpallett.com\/?p=331"},"modified":"2025-02-27T14:57:51","modified_gmt":"2025-02-27T22:57:51","slug":"interactive-text-tables-with-custom-sort-order","status":"publish","type":"post","link":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/","title":{"rendered":"Interactive Text Tables with Custom Sort Order"},"content":{"rendered":"\n

Make your text tables on dashboards shine with an easy, interactive, custom sort order feature. <\/p>\n\n\n\n

The concept is simple: give your dashboard viewers a handy-dandy drop-down menu so they can sort their table with the rows of most importance to them at the top.  I deployed this technique on my Help Desk Dashboard – click here <\/a>to see it in action.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

Note the Default Sort Order calculation appears in the \u201cValue when workbook opens\u201d spot in the parameter.<\/p>\n\n\n\n

Once the parameter is created, you can show the parameter and take a sneak peak at the appearance of the toggle.  <\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

Looks good! We are now ready for our next step, which requires us to use this parameter in a calculation.  A CASE statement works beautifully in this step. <\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

With this calculation, we are asking Tableau to do the following:<\/p>\n\n\n\n

When the toggle is set to Priority, Tableau will check the Priority ID and sort by this value. For your reference, the Priority ID in this dataset assigns High Priority the value of 20, Medium is 30, and Low is 40. For the rows to be listed from High to Low, we will want to use this calculation in Ascending Order: 20-30-40  (Tuck away that thought for later!)<\/p>\n\n\n\n

When the toggle is set to # of Days Open, we want Tableau to reference a calculation by the same name that counts the difference in days between Created Date and Closed Date, or in the case of tickets still open, the difference between Created Date and Today. Now, recall that we will be using this calculation in Ascending Order per the note above regarding Priority. This means we must place a negative sign in front of # of Days Open in order for the tickets with the longest # of days open to appear at the top. For example, if a ticket has been opened for 35 days, it will appear above a ticket that has only been opened for 2 days if we assign it a negative value (ascending order is -35 then -2). <\/p>\n\n\n\n

And last but not least, when the toggle is set to Ticket Number, we want Tableau to return a 0. Why? We built our text table with Ticket Number as the first value on the Rows shelf, so Tableau will use this value to sort the orders because our Sort Order calculation assigns a 0 to all rows in this setting.<\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

Last but not least, we need to activate this calculation by accessing the drop-down from the Ticket Number field on the rows shelf > Sort and follow the prompts to select the Sort Order field and Ascending order. <\/p>\n\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

So there you have it \u2013 with a couple of calculations and one parameter, you can add interactivity to your text table and give the dashboard viewer the control to see the rows of data in the order most relevant to them! <\/p>\n\n\n\n

Feel free to download my viz on Tableau Public<\/a> and take a look under the hood! <\/p>\n\n\n\n

Happy Vizzing! <\/p>\n","protected":false},"excerpt":{"rendered":"

Make your text tables on dashboards shine with an easy, interactive, custom sort order feature.  The concept is simple: give your dashboard viewers a handy-dandy drop-down menu so they can sort their table with the rows of most importance to them at the top.  I deployed this technique on my Help Desk Dashboard – click… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":330,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[4,3,21,16],"class_list":["post-331","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-viz-my-favourite-tips","tag-dataviz","tag-tableau","tag-tableaupublic","tag-tableautip","clear"],"yoast_head":"\nInteractive Text Tables with Custom Sort Order - 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\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Interactive Text Tables with Custom Sort Order - Sarah Pallett\" \/>\n<meta property=\"og:description\" content=\"Make your text tables on dashboards shine with an easy, interactive, custom sort order feature.  The concept is simple: give your dashboard viewers a handy-dandy drop-down menu so they can sort their table with the rows of most importance to them at the top.  I deployed this technique on my Help Desk Dashboard – click... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/\" \/>\n<meta property=\"og:site_name\" content=\"Sarah Pallett\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-27T22:02:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-27T22:57:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1319\" \/>\n\t<meta property=\"og:image:height\" content=\"1099\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/\"},\"author\":{\"name\":\"Sarah\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"headline\":\"Interactive Text Tables with Custom Sort Order\",\"datePublished\":\"2025-02-27T22:02:52+00:00\",\"dateModified\":\"2025-02-27T22:57:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/\"},\"wordCount\":590,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png\",\"keywords\":[\"DataViz\",\"Tableau\",\"TableauPublic\",\"TableauTip\"],\"articleSection\":[\"Data Viz - My Favourite Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/\",\"url\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/\",\"name\":\"Interactive Text Tables with Custom Sort Order - Sarah Pallett\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png\",\"datePublished\":\"2025-02-27T22:02:52+00:00\",\"dateModified\":\"2025-02-27T22:57:51+00:00\",\"author\":{\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"breadcrumb\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage\",\"url\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png\",\"contentUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png\",\"width\":1319,\"height\":1099},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sarahpallett.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Interactive Text Tables with Custom Sort Order\"}]},{\"@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":"Interactive Text Tables with Custom Sort Order - 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\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/","og_locale":"en_US","og_type":"article","og_title":"Interactive Text Tables with Custom Sort Order - Sarah Pallett","og_description":"Make your text tables on dashboards shine with an easy, interactive, custom sort order feature.  The concept is simple: give your dashboard viewers a handy-dandy drop-down menu so they can sort their table with the rows of most importance to them at the top.  I deployed this technique on my Help Desk Dashboard – click... Continue Reading →","og_url":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/","og_site_name":"Sarah Pallett","article_published_time":"2025-02-27T22:02:52+00:00","article_modified_time":"2025-02-27T22:57:51+00:00","og_image":[{"width":1319,"height":1099,"url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png","type":"image\/png"}],"author":"Sarah","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sarah","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#article","isPartOf":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/"},"author":{"name":"Sarah","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"headline":"Interactive Text Tables with Custom Sort Order","datePublished":"2025-02-27T22:02:52+00:00","dateModified":"2025-02-27T22:57:51+00:00","mainEntityOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/"},"wordCount":590,"commentCount":0,"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png","keywords":["DataViz","Tableau","TableauPublic","TableauTip"],"articleSection":["Data Viz - My Favourite Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/","url":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/","name":"Interactive Text Tables with Custom Sort Order - Sarah Pallett","isPartOf":{"@id":"https:\/\/sarahpallett.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage"},"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png","datePublished":"2025-02-27T22:02:52+00:00","dateModified":"2025-02-27T22:57:51+00:00","author":{"@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"breadcrumb":{"@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#primaryimage","url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png","contentUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png","width":1319,"height":1099},{"@type":"BreadcrumbList","@id":"https:\/\/sarahpallett.com\/index.php\/2025\/02\/27\/interactive-text-tables-with-custom-sort-order\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sarahpallett.com\/"},{"@type":"ListItem","position":2,"name":"Interactive Text Tables with Custom Sort Order"}]},{"@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":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2025\/02\/Dashboard-1.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/331","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=331"}],"version-history":[{"count":2,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/331\/revisions"}],"predecessor-version":[{"id":342,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/331\/revisions\/342"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/media\/330"}],"wp:attachment":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/media?parent=331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/categories?post=331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/tags?post=331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}