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
Term Description
Aggregation

Row-level data rolled up to a higher category, such as sum of sales or total profit. Tableau does this automatically so you can break data down to the level of detail that you want to work with.

Dimension vs Measure

Dimensions are qualitative data, such as a name or date. By default, Tableau automatically classifies data that contains qualitative or categorical information as a dimension, for example, any field with text or date values. These fields generally appear as column headers for rows of data, such as Customer Name or Order Date, and also define the level of granularity that shows in the view.

Measures are quantitative numerical data. By default, Tableau treats any field containing this kind of data as a measure, for example, sales transactions or profit. Data that is classified as a measure can be aggregated based on a given dimension, for example, total sales (Measure) by region (Dimension).

Continuous vs. Discrete

Continuous fields can contain an infinite number of values. This can be a range of values such as sales within a specific date range or quantities. Continuous fields are colored green in Tableau.

Discrete fields contain a finite number of values such as country, state, or customer name. Discrete fields are colored blue in Tableau.

More on Dimensions and Measures in the Learning Library.

Learn more: Tableau workspace controls and elements

In this section, you'll drag fields to the Columns and Rows shelves, and you'll also work with the Marks card. The image below identifies some of the workspace controls and elements that you'll use.

An overview of workspace elements

Element Description

A Undo

With Tableau, feel free to experiment with your data. You can always get back to where you started with the Undo button. Use this button to reverse the last action you performed in your workbook.

You can undo an unlimited number of times, back to the last time you opened the workbook, even after you saved your work.

B Data pane

Displays the name of the data source that is included in the view and the available fields as dimensions and measures. Fields can be grouped based on their owning table or by folder.

More on the Data Pane in the Learning Library.

C and D Cards and Shelves

Cards are containers for the different controls that are available in Tableau. Shelves are a type of card control. When you drag fields from the Data pane to the Columns or Rows shelves, the data is added as a column or a row on the axes in your view.

When you drag fields from the Data pane to the Marks card, you can control visual properties like type, color, size, shape, and more. Only the marks in your view are impacted by this action; axes do not change.

More on Cards and Shelves in the Learning Library.

E Show/Hide Cards

Did you accidentally hide a card that you now need? No problem! Just about everything on the Tableau workspace can be turned on or off to provide the maximum amount of room for you to create your visualizations.

To show or hide cards like Pages, Filters or Legends, click the drop-down arrow on the Show/Hide CardsShow/Hide Cards icon button on the toolbar and clear or enable the check mark for the card.

You can even collapse the Data and Analytics pane to the lower left corner of the workspace by clicking the MinimizeMinimize Data and Analytics pane button at the top-right corner of the pane. Click the button again to restore the pane like it was.

  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

To quickly change the chart type, select the drop-down menu on the Marks card.

For example, for an area chart, you can select Area.

Chart types listed in the Marks menu

Tableau supports many different chart types, referred to as mark types. For more information, see More on Mark Types in the Learning Library.

Note: Before you continue the tutorial, make sure your chart type is set back to Automatic.

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

Click the image to replay it.

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

    You can view or add data point information to your view. In this example, this information shows exact sales totals by category.

    To view information about each data point (that is, mark) in your view, hover over one of the bars to reveal a tooltip. The tooltip displays total sales for that category. Here is the tooltip for the Office Supplies category for 2021:

    A tooltip that shows Sales for Office Supplies in 2021

    To add data point information as labels to your view, click Show Mark Labels on the toolbar. Below, we show the total sales for each category and year.

    Note: In the Get Started tutorial, text labels are not added to the view.

    A bar chart that highlights the Show Mark Labels icon

    Learn more: Change your perspective

    To display the bar chart horizontally instead of vertically, click Swap Rows and Columns on the toolbar.

    Note: Undo this action before continuing the Get Started tutorial.

    A bar chart that highlights the Swap Rows and Columns icon

    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

If you want to see how your products contribute to overall sales by category, Tableau gives you another option.

If you drag the Sub-Category to Color on the Marks card, you create a stacked bar chart with additional marks for each sub-category identified by a unique color. Tableau automatically displays a legend card to the right for the Sub-Category values.

Note: Undo this action before continuing the Get Started tutorial.

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

This quickly shows you the amount of sales that each product contributes to the overall total for each category and year, and it immediately shows the large and small contributors at a glance.

Sub-categories are displayed as stacked bars in the order that they are listed in the legend, not according to where they fall on the Sales axis.

For example, the above view shows you that bookcases contributed 38,544 USD in sales to the overall total of 170,518 USD for Furniture in 2019. The mark is displayed at the top of the bar because Bookcases are listed above Chairs, Furnishings, and Tables in the legend. The sub-categories are displayed in the legend so that you can move them around and examine your data in a way that makes sense to you.

Depending on the kind of analysis you want to do, the stacked bar chart might or might not be the chart for you.

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

Click the image to replay it

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.

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