

{"id":9458,"date":"2024-10-30T08:14:03","date_gmt":"2024-10-30T00:14:03","guid":{"rendered":"https:\/\/www.dkmeco.com\/en\/?p=9458"},"modified":"2024-10-30T08:16:30","modified_gmt":"2024-10-30T00:16:30","slug":"give-a-chestnut-tableau-tips-13-use-containers-to-realize-maps-provinces-and-cities","status":"publish","type":"post","link":"https:\/\/www.dkmeco.com\/en\/give-a-chestnut-tableau-tips-13-use-containers-to-realize-maps-provinces-and-cities\/","title":{"rendered":"Give a chestnut! Tableau Tips (13): Use Containers to Realize Maps, Provinces and Cities"},"content":{"rendered":"<p>\n    <span style=\"font-size: 15px;\">Generally, if you want to drill down on the Tableau map, you need to search or filter. With these two methods, not only are there many steps, but each time you can only see the content of a certain province.<\/span>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">Wouldn&#8217;t it be better if we could combine the maps of the whole country with the maps of provinces and cities (as shown below)?<\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300483509054566.gif\" title=\"1621300483509054566.gif\" alt=\"\u6817\u5b5013\u52a8\u56fe1.gif\" style=\"margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; white-space: normal; background-color: rgb(250, 250, 250);\"\/>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">In this issue of &#8220;Cite a Chestnut&#8221;, the Tableau tips that Ada wants to share with you are: use containers to realize maps, provinces and cities details<\/span>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">*Create a province worksheet<\/span>\n<\/p>\n<p>\n    <span style=\"color: rgb(247, 150, 70);\"><strong><span style=\"font-size: 15px;\"><span style=\"margin: 0px; padding: 0px; box-sizing: border-box; font-size: 15px;\">Step 1\uff1a<\/span>Create a worksheet about province information, and name the worksheet province<\/span><\/strong><\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300495338029240.png\" title=\"1621300495338029240.png\" alt=\"\u622a\u5c4f2021-05-18 \u4e0a\u53489.13.08.png\" style=\"margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; white-space: normal; background-color: rgb(250, 250, 250);\"\/>\n<\/p>\n<p>\n    <span style=\"color: rgb(247, 150, 70);\"><strong><span style=\"font-size: 15px;\"><span style=\"margin: 0px; padding: 0px; box-sizing: border-box; font-size: 15px;\">Step 2\uff1a<\/span>Create City Worksheet<\/span><\/strong><\/span>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">Next, we create another worksheet about the city and name the worksheet city.<\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300502422063412.png\" title=\"1621300502422063412.png\" alt=\"\u622a\u5c4f2021-05-18 \u4e0a\u53489.13.14.png\" style=\"margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; white-space: normal; background-color: rgb(250, 250, 250);\"\/>\n<\/p>\n<p>\n    <span style=\"color: rgb(247, 150, 70);\"><strong><span style=\"font-size: 15px;\"><span style=\"margin: 0px; padding: 0px; box-sizing: border-box; font-size: 15px;\">Step 3\uff1a<\/span>Create dashboard and put in container<\/span><\/strong><\/span>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">We create a dashboard, and then put a horizontal container into the dashboard. Note that the container is framed in blue.<\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300510334046328.png\" title=\"1621300510334046328.png\" alt=\"\u622a\u5c4f2021-05-18 \u4e0a\u53489.13.21.png\" style=\"margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; white-space: normal; background-color: rgb(250, 250, 250); color: rgb(51, 51, 51); font-family: -apple-system, system-ui, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 17px; letter-spacing: 0.544px; text-align: justify;\"\/>\n<\/p>\n<p>\n    <span style=\"color: rgb(247, 150, 70);\"><strong><span style=\"font-size: 15px;\"><span style=\"margin: 0px; padding: 0px; box-sizing: border-box; font-size: 15px;\">Step 4\uff1a<\/span>Put the worksheet into the container<\/span><\/strong><\/span>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">Put these two tables in the container, then hide the title of the city table.<\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300517507009929.png\" title=\"1621300517507009929.png\" alt=\"\u622a\u5c4f2021-05-18 \u4e0a\u53489.13.27.png\" style=\"margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; white-space: normal; background-color: rgb(250, 250, 250); color: rgb(51, 51, 51); font-family: -apple-system, system-ui, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 17px; letter-spacing: 0.544px; text-align: justify;\"\/>\n<\/p>\n<p>\n    <span style=\"color: rgb(247, 150, 70);\"><strong><span style=\"font-size: 15px;\"><span style=\"margin: 0px; padding: 0px; box-sizing: border-box; font-size: 15px;\">Step 5\uff1a<\/span>Edit filter<\/span><\/strong><\/span>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">Click the dashboard menu, select the operation, and then add the operation as shown below.<\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300525451068778.png\" title=\"1621300525451068778.png\" alt=\"\u622a\u5c4f2021-05-18 \u4e0a\u53489.13.42.png\" style=\"margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; white-space: normal; background-color: rgb(250, 250, 250); color: rgb(51, 51, 51); font-family: -apple-system, system-ui, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 17px; letter-spacing: 0.544px; text-align: justify;\"\/>\n<\/p>\n<p>\n    <span style=\"color: rgb(247, 150, 70);\"><strong><span style=\"font-size: 15px;\"><span style=\"margin: 0px; padding: 0px; box-sizing: border-box; font-size: 15px;\">Step 6\uff1a<\/span>Change the city worksheet to floating<\/span><\/strong><\/span>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">If you want to achieve a better presentation, just change the city worksheet to floating.<\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300589251096758.png\" title=\"1621300589251096758.png\" alt=\"\u622a\u5c4f2021-05-18 \u4e0a\u53489.13.49.png\" style=\"margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; white-space: normal; background-color: rgb(250, 250, 250);\"\/>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">Note: You do n\u2019t need to worry that the small window of that province or city will always be there. Just click on the blank space of the map, and the content of that city will be hidden automatically.<\/span>\n<\/p>\n<p>\n    <img decoding=\"async\" src=\"\/upload\/ueditor\/image\/20210518\/1621300483509054566.gif\" title=\"1621300483509054566.gif\" alt=\"\u6817\u5b5013\u52a8\u56fe1.gif\" style=\"white-space: normal; margin: 0px; padding: 0px; display: inline-block; vertical-align: middle; border: none; box-sizing: border-box; background-color: rgb(250, 250, 250);\"\/>\n<\/p>\n<p>\n    <span style=\"font-size: 15px;\">With just a few simple steps, drilling down your map becomes very intuitive. Have you learnt that?<\/span>\n<\/p>\n<p>\n    <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Generally, if you want to drill down on the Tableau map, you need to search or filter. With these two<\/p>\n","protected":false},"author":92,"featured_media":9461,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":"","_wp_rev_ctl_limit":""},"categories":[1],"tags":[],"class_list":["post-9458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau"],"acf":[],"aioseo_notices":[],"rttpg_featured_image_url":{"full":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240.png",753,449,false],"landscape":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240.png",753,449,false],"portraits":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240.png",753,449,false],"thumbnail":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240-150x150.png",150,150,true],"medium":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240-300x179.png",300,179,true],"large":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240.png",753,449,false],"1536x1536":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240.png",753,449,false],"2048x2048":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240.png",753,449,false],"woodmart_shop_catalog_x2":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240-600x449.png",600,449,true],"woocommerce_thumbnail":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240-300x300.png",300,300,true],"woocommerce_single":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240-600x358.png",600,358,true],"woocommerce_gallery_thumbnail":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240-150x89.png",150,89,true],"rt_custom":["https:\/\/www.dkmeco.com\/en\/wp-content\/uploads\/2024\/10\/1621300495338029240.png",753,449,false]},"rttpg_author":{"display_name":"dkm-admin","author_link":"https:\/\/www.dkmeco.com\/en\/author\/dkm-admin\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.dkmeco.com\/en\/category\/tableau\/\" rel=\"category tag\">Tableau<\/a>","rttpg_excerpt":"Generally, if you want to drill down on the Tableau map, you need to search or filter. With these two","_links":{"self":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts\/9458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/comments?post=9458"}],"version-history":[{"count":1,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts\/9458\/revisions"}],"predecessor-version":[{"id":9460,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/posts\/9458\/revisions\/9460"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/media\/9461"}],"wp:attachment":[{"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/media?parent=9458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/categories?post=9458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dkmeco.com\/en\/wp-json\/wp\/v2\/tags?post=9458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}