{"id":281,"date":"2014-03-10T21:47:16","date_gmt":"2014-03-10T21:47:16","guid":{"rendered":"http:\/\/arunethan.com\/?p=281"},"modified":"2015-12-01T16:31:11","modified_gmt":"2015-12-01T16:31:11","slug":"tableau-parameter-as-a-filter","status":"publish","type":"post","link":"http:\/\/arunethan.com\/?p=281","title":{"rendered":"Tableau parameter as a filter"},"content":{"rendered":"<div class=\"pf-content\"><h2><span style=\"color: #000080;\">My Use-case<\/span><\/h2>\n<p>They are three different workbooks with data across years. Must link the workbooks together based on user selection of a year using parameters.<\/p>\n<h2><span style=\"color: #000080;\">Steps<\/span><\/h2>\n<p>1. Create the Year Parameter<\/p>\n<p><a href=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-282\" alt=\"2\" src=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/25.png\" width=\"679\" height=\"461\" srcset=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/25.png 970w, http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/25-300x203.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><\/p>\n<p>2. Drag the year dimension to filter box and open the condition tab<\/p>\n<p><a href=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/32.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-283\" alt=\"3\" src=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/32.png\" width=\"637\" height=\"449\" srcset=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/32.png 910w, http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/32-300x211.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/a><\/p>\n<p>3. Use the formula ([Year] = [Parameter 1])<\/p>\n<p><a href=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-284\" alt=\"4\" src=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/41.png\" width=\"752\" height=\"448\" srcset=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/41.png 1074w, http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/41-300x178.png 300w, http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/41-1024x610.png 1024w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/a><\/p>\n<p>4. Follow the step 2,3 for the other workbooks<\/p>\n<p><a href=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/119.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-285\" alt=\"1\" src=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/119.png\" width=\"694\" height=\"421\" srcset=\"http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/119.png 992w, http:\/\/arunethan.com\/wp-content\/uploads\/2014\/03\/119-300x182.png 300w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/a><\/p>\n<h2><span style=\"color: #000080;\">\u00a0Resources<\/span><\/h2>\n<p>Initial tableau dashboard <a href=\"http:\/\/arunkn.me\/Tableau\/DashboardLinkedbyParameter.twb\" target=\"_blank\">Parameter filter<\/a>\u00a0(Right-click and \u201cSave link as\u2026\u201d)<\/p>\n<h2><span style=\"color: #000080;\">Original Creation<\/span><\/h2>\n<p><a href=\"http:\/\/public.tableausoftware.com\/shared\/2QCDD7BPR?:display_count=no%20\" target=\"_blank\">http:\/\/public.tableausoftware.com\/shared\/2QCDD7BPR?:display_count=no\u00a0<\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>My Use-case They are three different workbooks with data across years. Must link the workbooks together based on user selection of a year using parameters. Steps 1. Create the Year Parameter 2. Drag the&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":285,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[27,39],"_links":{"self":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/281"}],"collection":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=281"}],"version-history":[{"count":3,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/281\/revisions"}],"predecessor-version":[{"id":288,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/281\/revisions\/288"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/media\/285"}],"wp:attachment":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=281"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}