{"id":346,"date":"2014-07-29T17:43:59","date_gmt":"2014-07-29T17:43:59","guid":{"rendered":"http:\/\/arunethan.com\/?p=346"},"modified":"2015-12-01T16:30:56","modified_gmt":"2015-12-01T16:30:56","slug":"sorting-in-tableau","status":"publish","type":"post","link":"http:\/\/arunethan.com\/?p=346","title":{"rendered":"Sorting in Tableau"},"content":{"rendered":"

Basic sort<\/span><\/h2>\n

Right click on the discrete1<\/sup> field in the rows or columns shelf<\/p>\n

1<\/sup> Sort can be performed only on discrete fields or measures which is converted to discrete<\/pre>\n
\"sort1\"<\/a><\/p>\n
The discrete field can be sorting by<\/p>\n
    \n
  1. Data source (if the field is pulled from a SQL data, this order is based on sort orders applied to this relation)<\/li>\n
  2. Alphabetically<\/li>\n
  3. Based on another Field across different aggregation level<\/li>\n<\/ol>\n
    \"sort1\"<\/a><\/p>\n
    Non-Nested Sort<\/span><\/h2>\n
    The nature of the sort function in Tableau is that sorting is done at the content level.<\/p>\n
    When a sort is done based on the SUM(profits) descending, you can notice that CENTRAL market is at the top. This because the aggregate SUM of CENTRAL is the maximum. Similarly COFFEE product type as a MAX of SUM(PROFIT) arranged descending. Hence it is at the top across all the Markets. The results are not sorted based on the Markets but to the entire context.<\/p>\n
    This is the default behavior within Tableau.<\/p>\n
     <\/p>\n
    \"sort2\"<\/a><\/p>\n
    Nested Sort<\/span><\/h2>\n
    If the results is expected to be sorted based on the markets,\u00a0 we have to create a nested sort using a work around.<\/p>\n
    In the dimensions pane, press the CTRL key, and then select the dimensions. Right-click on e of the selected fields and click on Combine Fields option. The newly combined field, Market & Product Type is created. Drag this field to the Rows panel and set the sort options. We will get a nested sort output.<\/p>\n
    \"sort3\"<\/a><\/p>\n
    Selected Sort<\/span><\/h2>\n
    With the previous sort you can add more measures but the results will still be still sorted by PROFIT<\/p>\n
    \"sort4\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
    <\/h2>\n
     <\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"
    Basic sort Right click on the discrete1 field in the rows or columns shelf 1 Sort can be performed only on discrete fields or measures which is converted to discrete The discrete field can...<\/p>\n","protected":false},"author":1,"featured_media":354,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[55,57,56,54,28],"_links":{"self":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/346"}],"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=346"}],"version-history":[{"count":6,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/346\/revisions"}],"predecessor-version":[{"id":358,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/346\/revisions\/358"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/media\/354"}],"wp:attachment":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}