{"id":10266,"date":"2018-03-08T12:05:33","date_gmt":"2018-03-08T12:05:33","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=10266"},"modified":"2025-03-05T20:09:03","modified_gmt":"2025-03-05T14:39:03","slug":"tableau-custom-data-view","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/","title":{"rendered":"Tableau Custom Data View – Drill Down, Swapping Dimension Operations"},"content":{"rendered":"

In this Tableau tutorial, we are going to study about Custom data view in Tableau, the commonly used operations in Tableau custom data view- Drill Down and Swapping Dimension operations in Tableau Custom Data View. At last we see some steps to create Drill down and Swapping dimensions. So let us start!!<\/p>\n

Tableau Custom Data View<\/h3>\n

A custom information see is utilized to expand the ordinary information sees with some extra highlights so the view can give diverse kinds of diagrams for the same basic information. For instance, you can bore down a measurement field which is a piece of a pre-characterized pecking order with the goal that extra estimations of the measures are gotten at an alternate granularity.<\/p>\n

Operations in Tableau Custom Data View<\/h3>\n

a. Drill down<\/h4>\n

STEP 1:<\/strong>\u00a0Discovered totally different levels of the hierarchy in several dashboards. Victimization the Superstore dataset as associate degree example, I even have discovered four totally different worksheets, every having an extra level of roughness than the previous:<\/p>\n

Level 1: Class
\nLevel 2: Category>Subcategory
\nLevel 3: Category>Subcategory>Product Name<\/p>\n

Each new sheet ought to be a replica of the previous to make sure the table scaling remains consistent.<\/p>\n

\"Drill<\/a>

Step 1. Drill Down Custom Data View in Tableau<\/p><\/div>\n

STEP 2: <\/strong>Currently, to create the buttons.<\/p>\n

Double click at the lowest of the marks card shelf. Write the text you wish to look on the button directly onto the shelf in quotation marks (so Tableau acknowledges it as a string). Then drag the pill you\u2019ve simply created to the \u2018Text\u2019 card. it’ll seem on the read in an exceedingly single cell.<\/p>\n

Learn this\u00a0Dealing With Data Quality Problems In Tableau<\/strong><\/a><\/p>\n

Alternatively, you’ll be able to choose associate degree icon to control as your button (see Emily\u2019s web log post).<\/p>\n

\"Step<\/a>

Step 2. Drill Down Custom Data View in Tableau<\/p><\/div>\n

You can then color the button by data formatting the fill of the Worksheet.<\/p>\n

\"Drill<\/a>

Step 2. Drill Down Custom Data View in Tableau<\/p><\/div>\n

Step 3:<\/strong>\u00a0Currently to create our Level one read dashboard.<\/p>\n

Open a brand new dashboard and drag the amount one worksheet onto the canvas. Then drag the \u2018More Granular\u2019 worksheet aboard it to bring the button onto the dashboard.<\/p>\n

\"Drill<\/a>

Step 3. Drill Down Custom Data View in Tableau<\/p><\/div>\n

Let’s produce our Level two read by duplicating the primary dashboard.<\/p>\n

Now drag your Level two worksheet aboard the amount one table, before deleting it. this may make sure that your new table occupies constant instrumentality because the previous \u2013 that is important for our \u2018flick-book\u2019 illusion.<\/p>\n

Let’s revise\u00a0Tableau Save, Reorder and Delete Worksheet<\/strong><\/a><\/p>\n

Since Level two is sandwiched between adjacent levels, we’d like to bring each the \u2018More Granular\u2019 and \u2018More Aggregated\u2019 buttons to the dashboard, to alter navigation each up and down.<\/p>\n

Repeat this method for all remaining Levels. On the foremost granular level but, solely offer the \u2018More Aggregated\u2019 button, as we are going to solely have the choice to maneuver up to higher levels.<\/p>\n

STEP 4:<\/strong>\u00a0Currently its time to activate links between levels within the hierarchy victimization Dashboard Actions.
\nMove back to your Level one read dashboard. choose \u2018Actions\u2019 from the Dashboard menu, associate degreed you’ll see an \u2018Add Filter Action\u2019 choices box (like below). Ticking the \u2018More Granular\u2019 hold in the supply sheet and choosing<\/p>\n

Run action on \u2018Select\u2019 can activate the \u2018More Granular\u2019 button.<\/p>\n

Changing \u2018Target Sheets\u2019 to the amount two read dashboard and un-ticking all the boxes can set our next level within the hierarchy because of the destination. This action primarily tells Tableau to maneuver to the amount two read once you click the \u2018More Granular\u2019 button on the amount one read.<\/p>\n

Follow this link for\u00a0Adding Worksheets And Renaming Worksheet In Tableau<\/a><\/strong><\/p>\n

While the layout of those dashboards is standardized, moving between them can produce the illusion of associate degree increasing table.<\/p>\n

\"Drill<\/a>

Step 4. Drill Down Custom Data View in Tableau<\/p><\/div>\n

On the amount two read dashboard, we’d like to follow constant protocol. However conjointly program the \u2018More aggregate\u2019 button to permit navigation back to the additional aggregated Level one read.<\/p>\n

Meanwhile, on the amount three read dashboard (the highest level of granularity) we tend to solely get to program a navigation back to the amount two dashboards.<\/p>\n

Once these action square measure totally programmed, the buttons can alter seamless navigation to adjacent dashboards with neighboring levels of detail, making the illusion of a drill-down hierarchy.
\nMust know about Joining Data in Tableau \u2013 Inner Join<\/strong><\/a><\/p>\n

b. Swapping Dimension<\/h4>\n

You can produce a replacement read from associate degree existing read by swapping the position of the size. This doesn’t modify the values of the measures. However, it will modification the position of the measures. take into account a read for analyzing the Profit for every year for every section and class of merchandise. Furthermore, you’ll click on the vertical line at the tip of a class column and drag it to the section column. This action is shown in the following screenshot.<\/p>\n

\"Swapping<\/a>

Swapping Dimension Custom Data View in Tableau<\/p><\/div>\n

Hence, the results of the swapping of the 2 dimensions are shown in the following screenshot. So you’ll see, solely the position of the values of the live Profit changes for every class and section, and not its price.
\nRead most popular books to learn Tableau<\/strong><\/a><\/p>\n

\"Swapping<\/a>

Swapping Dimension Custom Data View in Tableau<\/p><\/div>\n

Conclusion<\/h3>\n

Hence, In this tutorial, first of all, we studied the commonly used operations in Tableau custom data view. At last we saw uses of custom data view and operations which can use to increase the functionality in Tableau. Furthermore, if you have any query, feel free to ask in a comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this Tableau tutorial, we are going to study about Custom data view in Tableau, the commonly used operations in Tableau custom data view- Drill Down and Swapping Dimension operations in Tableau Custom Data...<\/p>\n","protected":false},"author":5,"featured_media":10274,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[3223,4064,9278,14011,14206,15997],"class_list":["post-10266","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-custom-data-view-in-tableau","tag-drill-down","tag-operations-in-tableau-custom-data-view","tag-swapping-dimension","tag-tableau-custom-data-view","tag-what-is-tableau-custom-data-view"],"yoast_head":"\nTableau Custom Data View - Drill Down, Swapping Dimension Operations - DataFlair<\/title>\n<meta name=\"description\" content=\"What is Custom Data View in tableau, Operations in Tableau Custom Data View, Drill down, Swapping Dimension with examples etc.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau Custom Data View - Drill Down, Swapping Dimension Operations - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What is Custom Data View in tableau, Operations in Tableau Custom Data View, Drill down, Swapping Dimension with examples etc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-08T12:05:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-05T14:39:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Custom-Data-View.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tableau Custom Data View - Drill Down, Swapping Dimension Operations - DataFlair","description":"What is Custom Data View in tableau, Operations in Tableau Custom Data View, Drill down, Swapping Dimension with examples etc.","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:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/","og_locale":"en_US","og_type":"article","og_title":"Tableau Custom Data View - Drill Down, Swapping Dimension Operations - DataFlair","og_description":"What is Custom Data View in tableau, Operations in Tableau Custom Data View, Drill down, Swapping Dimension with examples etc.","og_url":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-08T12:05:33+00:00","article_modified_time":"2025-03-05T14:39:03+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Custom-Data-View.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Tableau Custom Data View – Drill Down, Swapping Dimension Operations","datePublished":"2018-03-08T12:05:33+00:00","dateModified":"2025-03-05T14:39:03+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/"},"wordCount":1002,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Custom-Data-View.jpg","keywords":["Custom Data View in Tableau","Drill down","Operations in Tableau Custom Data View","Swapping Dimension","Tableau Custom Data View","What is Tableau Custom Data View"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/","url":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/","name":"Tableau Custom Data View - Drill Down, Swapping Dimension Operations - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Custom-Data-View.jpg","datePublished":"2018-03-08T12:05:33+00:00","dateModified":"2025-03-05T14:39:03+00:00","description":"What is Custom Data View in tableau, Operations in Tableau Custom Data View, Drill down, Swapping Dimension with examples etc.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Custom-Data-View.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Custom-Data-View.jpg","width":1200,"height":628,"caption":"What is Tableau Custom Data View"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-custom-data-view\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Tableau Custom Data View – Drill Down, Swapping Dimension Operations"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=10266"}],"version-history":[{"count":7,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10266\/revisions"}],"predecessor-version":[{"id":144488,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10266\/revisions\/144488"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/10274"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=10266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=10266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=10266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}