Drill through reports in tableau

drill through reports in tableau

Extreme Close Up: let

As you clear each member, the profit for Tennessee, north Carolina, and Florida improve, until finally, each has a positive profit. Click the image to replay it hey, you found something! Binders, machines, and tables are definitely responsible for the losses in Tennessee, north Carolina, and Florida, but not for the rest of the south. Do you notice how profit actually decreases for some of the other states as you clear items from the filter card? For example, if you toggle binders on the sub-Category filter card, profit drops by four percent in Arkansas. You can deduce that Binders are actually profitable in Arkansas. You want to share this discovery with the team by walking them through the same steps you took.

Tableau, users drill down from

A filter card for all of the products you offer appears next to the map view. This will come in handy in just a second. From measures, drag Profit and Profit Ratio to label on the marks card. Now you can see the exact profit of each state without having to hover your cursor over them. On the data pane, right-click Order Date and select Show Filter to provide some context for the view. A filter card for year(Order Date) appears in the view. You can now view profit for all years or for a combination of years. This might writing be useful for your presentation. Clear Binders, machines, and Tables from the list on the sub-Category filter card in the view. Recall that adding filters to your view lets you include and exclude values global to highlight certain parts of your data.

Drag Profit to color on the marks card to make it easier to see which products have negative profit. In the data pane, right-click Order Date and select Show Filter. You can now explore negative profits for each year if you want, and quickly spot the products that are losing money. Machines, tables, and binders dont seem to be doing well. So what if you stop selling those items in Jacksonville, concord, burlington, Knoxville, and Memphis? Top verify your findings Will eliminating binders, machines, and tables improve profits in Florida, north Carolina, and Tennessee? To find out, you can filter out the problem products to see what happens. Go back to your map view by clicking the Profit Map sheet tab. On the data pane, right-click sub-Category and select Show Filter.

drill through reports in tableau

Clickable Drillable cascading Dynamic Parameters in Tableau

Drag Postal Code off the rows shelf. Your view book updates to look like this: Check your work! . Watch steps 3-8 in action. Click the image to replay it Now that you've focused your view to the least profitable cities, you can investigate further to identify the products responsible. Top Identify the troublemakers you decide to break up the view by sub-Category to identify the products dragging profit down. You know that the sub-Category field contains information about products sold by location, so you start there. Drag Sub-Category to the rows shelf, and place it to the right of City.

So now what's going on? Jacksonville, nc is included because city is the lowest level of detail shown in the view. For Tableau desktop to know the difference between Jacksonville, nc, and Jacksonville, fl, you need to drill down to the next level of detail in the location hierarchy, which, in this case, is Postal Code. After you do this, you can exclude jacksonville in North Carolina without also excluding Jacksonville in Florida. On the rows shelf, click the plus icon on City to drill down to the postal Code level of detail. Right-click the postal code for Jacksonville, nc, 28540, and then select Exclude. Postal Code is added to the filters shelf to indicate that certain members in the postal Code field have been filtered from the view. Even when you remove the postal Code field from the view, the filter will remain.

Acquiring immediate sites is new Land Director's plan

drill through reports in tableau

End-of-the-year Activities & Lessons

There are three fields on the filters shelf: Region (a dimension filter city (a top N filter and Inclusions (Country, state) (Country, state) (a set). If you look at the order of operations again, you know that the set health and the top N filter are being applied before the dimension filter. But do you know if the top N filter or the set filter is being applied first? This is a good place to look for the culprit. On the filters shelf, right-click the city field and select Add to context. The city field turns gray and moves to the top of the filters shelf, but nothing changes in the view. So even though you're forcing Tableau to filter City first, the issue doesn't resolve itself.

On the filters shelf, right-click the Inclusions (Country, state) (Country, state) set and select Add to context. The Inclusions (Country, state) (Country, state) set turns gray and moves to the top of the filters shelf. Another mark appears in the view! You also notice that miami, florida disappeared. That's because concord actually had lower profit than miami, but the way the filters were being applied, it was not included. You're on to something! But Jacksonville, north Carolina is still in the view.

You can now see that Jacksonville and miami, florida; Burlington, north Carolina; and Knoxville and Memphis, tennessee are the poorest performing cities by profit. There is one other mark in the view—Jacksonville, north Carolina—that doesn't belong, because sales in that city are actually profitable. What is going on here? Why would a city with a positive profit show up in the view when you created a filter that was supposed to filter it out? That's a great question, and a great reason to introduce the tableau order of Operations.


The tableau order of Operations, also known as the query pipeline, is the order that Tableau performs various actions, such as the order in which it applies your filters to the view. Tableau applies filters in the following order: Extract Filters Data source filters Context Filters Top n filters Dimension Filters measure filters The order in which you create filters, or arrange them on the filters shelf has nothing to do with the order in which Tableau. The good news is you can tell Tableau to change this order when you notice something strange happening with the filters in your view, like with the imposter, jacksonville, carolina in your view right now. All you need to do is add a filter to context. This will tell Tableau to filter that field first, regardless of where it falls on the order of operations. But which field do you add to context?

Daily answer writing challenge insights

In this case, writings you want to use the top n filter to hone in on poor performers. From the data pane, drag City to the filters shelf. In the filter dialog box, select the top tab, and then do the following: Click by field. Click the top drop-down and select Bottom to reveal the poorest performers. Type 5 in the text box to show the bottom 5 performers in your data set. Tableau desktop has already selected a field (Profit) and aggregation (Sum) for the top n filter based on the fields in your view. These settings ensure that your view will display only the five poorest performing cities by sum of profit.

drill through reports in tableau

You can edit this biography field by right-clicking the field on the filters shelf and selecting, Edit Filter. Click the image to replay. Now you want to look at the data for the cities in these states. On the rows shelf, click the plus icon on the State field to drill-down to the city level of detail. Click the image to replay it Theres almost too much information here, so you decide to filter the view down to the cities with the most negative profit. How will you do this? With a top n filter. Watch "Pick up where your map view left off" in action. Click the image to replay it Top Create a top n filter you can use a top n filter in Tableau desktop to set a limit to the number of marks displayed in your view.

and, florida. On the tooltip that appears, select. Keep Only to focus on those three states. Note: you can also right-click one of the highlighted bars, and select. Notice that an, inclusions field for State is added to the filters shelf to indicate that certain states are filtered from the view. The icon with two circles on the field indicates that this field is a set.

A bar chart will help you get into the nitty-gritty. To do this, you create another worksheet. Double-click, sheet 3 and name the worksheet, profit Map. Right-click, profit Map at the bottom of the workspace and select. Name this one, negative profit Bar Chart. In the negative profit Bar Chart estate worksheet, click. Show me, and then select horizontal bars. Show me highlights different chart types based on the data you've added to your view.

11 tips on getting a first class degree, save the Student

Was this page helpful? Yes no, have a comment? Please leave it here. Thanks for your feedback! In the last step you discovered that Tennessee, north Carolina, and Florida have negative profit. To find out why, you decide to drill down even further and focus on what's happening in those three states alone. Pick up where your map view left off. As you saw in the last step, maps paper are great for visualizing your data broadly.


Drill through reports in tableau
all articles 43 articles
Youre author of a biography of Albert Einstein called, einstein. Tennysons poems questions and Answers. Oh, i could sit here and think of more, but you probably can think of more than I can.

6 Comment

  1. Exploring Medicare part d data in Tableau the idea behind these reports is to allow.

  2. Learn how to use tableau s drill down capabilities and how to build your own h ierarchies. Extreme Close Up: let Tableau users drill down from Aggregates. They can look at a sfdc report, which will pull literally a list of those. Drill Down and Up by date Inside of a tableau line Chart. Way t o offer a high- level summary with the option to drill down into the data.

  3. As mentioned, try playing around with actions in the worksheet heading in the data menu. You can also set a worksheet to behave as a filter for other worksheets. In the last step you discovered that Tennessee, north Carolina, and Florida have n egative profit. To find out why, you decide to drill down even further and focus. I have 50 states in my data and respective counties of those states. First level i need to see the states in filled map, then if I click on any state.

Leave a reply

Your e-mail address will not be published.


*