Step 2: Drag and drop to take a first look

Create a view

You set out to identify key areas for improvement, but where to start? With four years' worth of data, you decide to drill into the overall sales data to see what you find. Start by creating a simple chart.

Learn more: Terms in this section
Learn more: Tableau workspace controls and elements
  1. From the Data pane, drag Order Date to the Columns shelf.

    Note: When you drag Order Date to the Columns shelf, Tableau creates a column for each year in your data set. Under each column is an Abc indicator. This indicates that you can drag text or numerical data here, like what you might see in an Excel spreadsheet. If you were to drag Sales to this area, Tableau creates a crosstab (like a spreadsheet) and displays the sales totals for each year.

  2. From the Data pane, drag Sales to the Rows shelf.

    Tableau generates the following chart with sales rolled up as a sum (aggregated). You can see total aggregated sales for each year by order date.

  3. Line chart that uses Order Date for the Columns Shelf and Sum(Sales) for the Rows shelf

    When you first create a view that includes time (in this case Order Date), Tableau automatically generates a line chart.

This line chart shows that sales look pretty good and seem to be increasing over time. This is good information, but it doesn't really tell you much about which products have the strongest sales and if there are some products that might be performing better than others. Since you just got started, you decide to explore further and see what else you can find out.

Learn more: Explore your options

Check your work! Watch "Create a view" in action

Click the image to replay it.

An animation of dragging Order Date to the Columns shelf and Sum(Sales) to the Rows shelf

Refine your view

To gain more insight into which products drive overall sales, try adding more data. Start by adding the product categories to look at sales totals in a different way.

  1. From the Data pane, drag Category to the Columns shelf and place it to the right of YEAR(Order Date).

    Your view updates to a bar chart. By adding a second discrete dimension to the view you can categorize your data into discrete chunks instead of looking at your data continuously over time. This creates a bar chart and shows you overall sales for each product category by year.

    A bar chart that has Year(Order Date) and Category on the Columns shelf and Sum(Sales) on the Rows shelf

  2. Learn more: Show me the numbers
    Learn more: Change your perspective

    Your view is doing a great job showing sales by category—furniture, office supplies, and technology. An interesting insight is revealed!

    From this view, you can see that sales for furniture is growing faster than sales for office supplies, even though Office Supplies had a really good year in 2021. Perhaps you can recommend that your company focus sales efforts on furniture instead of office supplies? Your company sells a lot of different products in those categories, so you'll need more information before you can make a recommendation.

    To help answer that question, you decide to look at products by sub-category to see which items are the big sellers. For example, for the Furniture category, you want to see details about bookcases, chairs, furnishings, and tables. Looking at this data might help you gain insights into sales and later on, overall profitability, so add sub-categories to your bar chart.

  1. Double-click or drag Sub-Category to the Columns shelf.
  2. Note: You can drag and drop or double-click a field to add it to your view, but be careful. Tableau makes assumptions about where to add that data, and it might not be placed where you expect. You can always click Undo to remove the field, or drag it off the area where Tableau placed it to start over.

    Sub-Category is another discrete field. It creates another header at the bottom of the view, and shows a bar for each sub-category (68 marks) broken down by category and year.

    A bar chart that shows Order Date, Category, and Sub-Category on the Columns shelf and Sum(Sales) on the Rows shelf

Now you are getting somewhere, but this is a lot of data to visually sort through. In the next section, you will learn how you can add color, filters, and more to focus on specific results.

Learn more: Use a different view to compare product sales

Check your work! Watch "Refine your view" in action

Click the image to replay it

An animation of dragging Category and Sub-Category to the Columns shelf and then dragging Sub-Category to Color on the Marks card

Step summary

This step was all about getting to know your data and starting to ask questions about your data to gain insights. You learned how to:

  • Create a chart in a view that works for you.

  • Add fields to get the right level of detail in your view.

Now you're ready to begin focusing on your results to identify more specific areas of concern. In the next section, you will learn how to use filters and colors to help you explore your data visually.

Continue to Step 3: Focus your results.