Step 3: Focus your results

You've created a view of product sales broken down by category and sub-category. You are starting to get somewhere, but that is a lot of data to sort through. You need to easily find the interesting data points and focus on specific results. Well, Tableau has some great options for that!

Filters and colours are ways you can add more focus to the details that interest you. After you add focus to your data, you can begin to use other Tableau Desktop features to interact with that data.

Add filters to your view

You can use filters to include or exclude values in your view. In this example, you decide to add two simple filters to your worksheet to make it easier to look at product sales by sub-category for a specific year.

  1. In the Data pane, right-click Order Date and select Show Filter.

  2. Repeat the step above for the Sub-Category field.

    The filters are added to the right side of your view in the order that you selected them. Filters are card types and can be moved around on the canvas by clicking on the filter and dragging it to another location in the view. As you drag the filter, a line appears that shows you where you can drop the filter to move it.

    Note: The Get Started tutorial uses the default position of the filter cards.

    More on Filtering in the Learning Library (in the top menu).

  3. A bar chart with filters for Sub-Category and Order Date

Check your work! Watch "Apply filters to your view" in action

Click the image to replay it

Add colour to your view

Adding filters helps you to sort through all of this data – but wow, that’s a lot of blue! It's time to do something about that.

Currently, you are looking at sales totals for your various products. You can see that some products have consistently low sales, and some products might be good candidates for reducing sales efforts for those product lines. But what does overall profitability look like for your different products? Drag Profit to colour to see what happens.

From the Data pane, drag Profit to Colour on the Marks card.

By dragging profit to colour, you now see that you have negative profit in Tables, Bookcases and even Machines. Another insight is revealed!

A bar chart with Order Date, Category and Sub-Category on the Columns shelf; Sum(Sales) on the Rows shelf and Sum(Profit) on Colour on the Marks card

Note: Tableau automatically added a colour legend and assigned a diverging colour palette because your data includes both negative and positive values.

Learn more: Working with colour

Adding colour visually enhances your view, but it can also make interesting data stand out. Tableau uses a default colour palette to assign colours to the products in your view, but you aren't limited to that colour palette. You have choices!

If you want to use different colours than the ones shown, you can change the colours or colour palette at any time. Simply click Colour on the Marks card, and then click Edit Colours. You can select a different colour palette in the Edit Colours dialog box that opens.

Note: The Get Started tutorial uses the default colour palette.

Depending on the data in your view, the Edit Colours dialog box might show you a diverging colour palette versus a categorical colour palette.

Diverging colour palettes look like the image below. Diverging colour palettes are generally assigned to continuous fields.

Diverging colour palettes listed in the Edit Colours menu

If you're using a legend, it might look like the image below. Categorical colour palettes like this one are generally assigned to discrete fields.

Categorical colour palettes listed in the Edit Colours menu

Check your work! Watch "Add colour to your view" in action

Click the image to replay it

Find key insights

As you've learned, you can explore your data as you build views with Tableau Desktop. Adding filters and colours helps you better visualise your data and can identify problems right away.

The next step is to interact with your view so that you can begin drawing conclusions.

Looking at your view, you saw that you had some unprofitable products, but now you want to see if these products have been unprofitable year over year.

It's time to use your filters to take a closer look.

  1. In the view, in the Sub-Category filter card, clear all of the check boxes except Bookcases, Machines and Tables.

    A bar chart with a diverging colour palette to show profits and losses for Sub-Categories

    Now you can see that, in some years, Bookcases and Machines were profitable. However, recently Machines are unprofitable. While you've made an important discovery, you want to gather more information before proposing any action items to your boss.

    On a hunch, you decide to break up your view by region:

  2. Select All in the Sub-Category filter card to show all sub-categories again.

  3. From the Data pane, drag Region to the Rows shelf and place it to the left of Sum(Sales).

    Tableau creates a view with multiple axes broken down by region.

    Bar charts that show profits by region using a diverging colour palette

  4. Now you see sales and profitability by product for each region. By adding region to the view and filtering the Sub-Category for Machines only, you notice that machines in the South are reporting a higher negative profit overall than in your other regions. You've discovered a hidden insight!

    Bar charts that show the profitability of the Machines Sub-Category across each region

    This view best encapsulates your work so far. Select All in the Sub-Category filter card (if you changed your filter) to show all sub-categories again, name the worksheet and add a title.

  5. At the bottom-left of the workspace, double-click Sheet 1 and type Sales by Product/Region.

    You choose to focus your analysis on the South, but you don't want to lose the view you've created. In Tableau Desktop, you can duplicate your worksheet to continue where you left off.

  6. In your workbook, right-click the Sales by Product/Region sheet and select Duplicate.

  7. Rename the duplicated sheet to Sales in the South.

  8. In your new worksheet, from the Data pane, drag Region to the Filters shelf to add it as a filter in the view.

  9. In the Filter Region dialog box, clear all check boxes except South and then click OK.

    Your view updates to look like the image below.

    A bar chart that shows the profitability of Sub-Category in the South

    Now you can focus on sales and profit in the South. You immediately see that machine sales had negative profit in 2018 and again in 2021. This is definitely something to investigate!

  1. Save your work by selecting FileSave As. Give your workbook a name, such as Regional Sales and Profits.

  2. Learn more: How Tableau organises your saved workbooks

    When you install Tableau, it automatically creates a folder directory for you under Documents > My Documents > My Tableau Repository. My Tableau Repository contains multiple folders for data sources, saved workbooks, geocoding data and more.

    More on saving your workbook as different Tableau file types in the Learning Library (in the top menu).

 

Check your work! Watch "Find key insights" in action below

Click the image to replay it

Step summary

In this step you used filter and colour to make working with your data a bit easier. You also learned about a few fun features that Tableau offers to help you answer key questions about your data. You learned how to:

  • Apply filters and colour to make it easier to focus on the areas of your data that interest you the most.

  • Interact with your chart using the tools that Tableau provides.

  • Duplicate worksheets and save your changes to continue exploring your data in different ways without losing your work.

Having explored your data in Tableau Desktop, you've identified areas of concern. You know sales and profit in the South are a problem, but you don't yet have a solution. You want to look at other factors that might be contributing to these results. Next, you'll leverage another key feature in Tableau to work with geographic data.

Continue to Step 4: Explore your data geographically.

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!