#TABLEAU TABULAR REPORT PLUS#

To fix the chart, add a filter to context. In this example, the Top N Filter is applied to the five poorest performing cities by sum of profit for the whole map, but none of those cities are in the South, so the chart is blank. The good news is you can tell Tableau to change this order when you notice something strange happening with the filters in your view.

The order that you create filters in, or arrange them on the Filters shelf, doesn't change the order in which Tableau applies those filters to your view.

Tableau applies filters in the following order: 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. What happened to the bar chart, and why is it blank? That's a great question, and a great opportunity to introduce the Tableau Order of Operations. These settings ensure that your view will display only the five poorest performing cities by sum of profit. Tableau Desktop has already selected a field (Profit) and aggregation (Sum) for the Top N Filter based on the fields in your view. Type 5 in the text box to show the bottom 5 performers in your data set. In the Filter dialog box, select the Top tab, and then do the following:Ĭlick the Top drop-down and select Bottom to reveal the poorest performers. In this case, you want to use the Top N Filter to hone in on poor performers.įrom the Data pane, drag City to the Filters shelf. You can use a Top N Filter in Tableau Desktop to limit the number of marks displayed in your view. Check your work! Watch steps 1-5 in action

There’s almost too much information here, so you decide to filter the view down to the cities with the most negative profit by using a Top N Filter.

#TABLEAU TABULAR REPORT PLUS#

On the Rows shelf, click the plus icon on the State field to drill-down to the City level of detail. Now you want to look at the data for the cities in these states. You can edit this field by right-clicking the field on the Filters shelf and selecting, Edit Filter. The icon with two circles on the field indicates that this field is a set. Notice that an Inclusions field for State is added to the Filters shelf to indicate that certain states are filtered from the view. Note: You can also right-click one of the highlighted bars, and select Keep Only. On the tooltip that appears, select Keep Only to focus on those three states. To select multiple bars on the left, click and drag your cursor across the bars between Tennessee, North Carolina, and Florida. You now have a bar chart again-just like that. Note: At any time, you can click Show Me again to collapse it. Show Me highlights different chart types based on the data you've added to your view.

In the Negative Profit Bar Chart worksheet, click Show Me, and then select horizontal bars. Name the new sheet Negative Profit Bar Chart. Right-click Profit Map at the bottom of the workspace and select Duplicate. To do this, you create another worksheet.ĭouble-click Sheet 3 and name the worksheet Profit Map. A bar chart will help you get into the nitty-gritty. Pick up where your map view left offĪs you saw in the last step, maps are great for visualizing your data broadly. To find out why, you decide to drill down even further and focus on what's happening in those three states alone. In the last step you discovered that Tennessee, North Carolina, and Florida have negative profit.

Tableau tabular report