{"id":233,"date":"2014-03-07T21:49:37","date_gmt":"2014-03-07T21:49:37","guid":{"rendered":"http:\/\/arunethan.com\/?p=233"},"modified":"2015-12-01T16:29:57","modified_gmt":"2015-12-01T16:29:57","slug":"tableau-combination-chart","status":"publish","type":"post","link":"http:\/\/arunethan.com\/?p=233","title":{"rendered":"Tableau combination chart"},"content":{"rendered":"

My Use-case<\/span><\/h2>\n

To display a chart with Number of stores across years, differentiating each year by category of the store. In addition, have an overlay that would show the total for the given year based on user selection. This should not modify the underlying chart.<\/p>\n

Step 1:<\/p>\n

    \n
  1. Create a Stacked chart<\/li>\n<\/ol>\n

    \"1\"<\/a><\/p>\n

    Rows:\u00a0<\/b>Aggregate of number of stores<\/em><\/address>\n
    Columns:\u00a0<\/b>Years <\/b><\/em><\/address>\n
    Filter:\u00a0<\/b>The category of interest (Apparel specialty, supermarket, value market, department store)<\/em><\/address>\n
    Color: <\/b>Category \u00a0<\/b><\/em><\/address>\n
    \u00a0<\/address>\n
    \u00a02. Overlaying chart<\/address>\n

    2.1. Create a parameter using Year field and select years from 2000 to 2007<\/span><\/p>\n

    \"1\"<\/a><\/p>\n

    2.2.\u00a0Create a calculated field Highlight Year (IF [Year]=[Parameter 1] THEN 1 END)<\/p>\n

    \"1\"<\/a><\/p>\n

    2.3.\u00a0Display the parameter in the sheet and make it a slider, move the Highlight Year to rows shelf\"1\"<\/a><\/p>\n

    2.4. Make the Highlight Year row as a dual Axis<\/p>\n

    \"1\"<\/a><\/p>\n

    2.5.\u00a0Right click on the right hand side axis and synchronize the Axis<\/p>\n

    \"1\"<\/a><\/p>\n

    2.6.In the Sum (Highlight Year) marks; remove category from color<\/p>\n

    \"1\"<\/a><\/p>\n

    2.7. Change the color to white and transparency to 40%<\/p>\n

    \"2\"<\/a><\/p>\n

    2.8. Change the size to lesser size using the slider<\/p>\n

    \"2\"<\/a><\/p>\n

    2.9. Add the number of stores to the label<\/p>\n

    \"2\"<\/a><\/p>\n

    Resources:<\/strong><\/p>\n

    Initial tableau workbook Combination Chart<\/a>\u00a0(Right-click and “Save link as…”)<\/p>\n

    Original creation:<\/strong><\/p>\n

    http:\/\/public.tableausoftware.com\/shared\/2QCDD7BPR?:display_count=no\u00a0<\/a><\/p>\n

     <\/p>\n

     <\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

    My Use-case To display a chart with Number of stores across years, differentiating each year by category of the store. In addition, have an overlay that would show the total for the given year...<\/p>\n","protected":false},"author":1,"featured_media":265,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[37,36,35],"_links":{"self":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/233"}],"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=233"}],"version-history":[{"count":12,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/233\/revisions"}],"predecessor-version":[{"id":279,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/233\/revisions\/279"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/media\/265"}],"wp:attachment":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=233"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}