Skip to content
Tutorials Center
My learning

Topics

Lesson 4 of 35 ยท Welcome to Tableau

Your First Tableau Visualization: Worksheets, Aggregation and Show Me

Build your first Tableau chart step by step: add and rename worksheets, drag fields, change the aggregation, reorder pills, sort by field, and use Show Me to pick a chart.

You know the screen and the field types. Now build something. This lesson walks through the first chart end to end, then covers the five habits you will use in every worksheet: renaming and duplicating sheets, ordering pills, changing the summary, sorting, and letting Show Me suggest a chart type.

The instructions describe the Tableau interface. Each interface step is followed by a runnable SQL stand-in on the shared orders table so you can see the numbers behind it.

Worksheets: add, rename, duplicate

A new workbook opens with a worksheet called Sheet 1. Add more with the New Worksheet tab icon at the bottom or Ctrl+T. To keep a project readable:

  • Rename by double-clicking the tab. Use names that describe the result: Sales by Region.
  • Duplicate by right-clicking the tab and choosing Duplicate (or Duplicate as Crosstab to get the numbers behind the chart).
  • Color a tab so related sheets stand out in a big workbook.
  • Clear a sheet to start again without deleting it. Analysis menu actions can all be undone.

Build a bar chart in five steps

  1. Open a worksheet. In the Data pane find Region (a dimension) and Sales (a measure).
  2. Drag Region to Rows. You get a header for each region and no marks yet.
  3. Drag Sales to Columns. Tableau sums it automatically and draws one horizontal bar per region.
  4. Drag Category to Color on the Marks card. Each bar is split into colored segments.
  5. Click the Label button on the Marks card and tick Show mark labels so values print on the bars.

You have just described three things: the grouping (Region, Category), the measure (SUM of Sales) and the marks' look (bar, color, label). That is the whole model.

SQL Stand-in: the numbers behind the five steps

Press Run (or Ctrl + Enter) to see the result here.

Change the order of fields

The order of pills on a shelf matters. Two dimensions on Rows nest from left to right: Region then Category gives one block per region, with categories inside it. Swap them by dragging a pill past the other, and the nesting flips: one block per category, with regions inside.

  • The pill leftmost on Rows (or topmost on Columns) is the outermost grouping.
  • Put a field on Color instead of a shelf to avoid extra headers.
  • To swap rows and columns entirely, click Swap Rows and Columns (Ctrl+W) in the toolbar. The bar chart turns vertical.

Change the summary (aggregation)

A measure on a view always has an aggregation. Right-click the pill, open Measure (Sum) and choose another:

Aggregation Meaning
Sum Add the values
Average Mean of the values
Median Middle value
Count Number of rows with a value
Count (Distinct) Number of different values
Minimum / Maximum Smallest and largest
Std. Dev, Variance Spread

The same pill can show wildly different stories under different aggregations, so always read the pill name. AVG(Profit) per order is not SUM(Profit) per region.

You can also turn aggregation off with Analysis > Aggregate Measures. Tableau then draws one mark per row. That is useful for scatter plots of individual orders, but be careful with large tables.

SQL Stand-in: five aggregations of the same measure

Press Run (or Ctrl + Enter) to see the result here.

Sorting

Tableau offers several ways to sort. On a bar chart:

  • Toolbar sort buttons: click Sort Ascending or Sort Descending in the toolbar. Tableau sorts the dimension by the measure on the view.
  • Axis hover icon: hover a header or axis and click the small sort icon.
  • Sort dialog: right-click a dimension pill and choose Sort. Pick Sort By: Field (choose the measure and the aggregation), Alphabetic, Data source order or Manual.

Sorting is not a one-off action: Tableau stores it as a setting on the pill, so it follows the data when you filter.

SQL Stand-in: Sort By Field, descending

Press Run (or Ctrl + Enter) to see the result here.

We cover manual and data-source-order sorting in Groups, sets, hierarchies and parameters.

Show Me

Show Me is the panel in the top right that lists chart types as small thumbnails. You select fields in the Data pane (hold Ctrl to pick several) and Show Me highlights the chart types that work for them. A click converts the view.

Show Me checks the number and type of fields. Rough guide:

Fields you selected Chart types it enables
1 dimension + 1 measure Bar, text table, pie, treemap, bubble
1 date + 1 measure Line charts (continuous or discrete)
2 measures Scatter plot, dual lines
1 measure Histogram (it creates bins)
geographic dimension + measure Symbol map, filled map
2 dimensions + 1 measure Heat map, highlight table, side-by-side bars

The hint text at the bottom of Show Me says what a greyed-out chart needs, for example "1 or more dimensions and 1 or 2 measures". Use Show Me to learn, but do not rely on it: once you know which pills each chart needs, dragging them yourself is faster and teaches you the model.

If the result looks odd after using Show Me, look at the shelves. Show Me only moves pills for you. You can still change the aggregation, color or mark type afterwards.

Common mistakes

  • Forgetting the aggregation. Read the pill: SUM(Sales) and AVG(Sales) are different numbers.
  • Nesting dimensions in the wrong order, so the chart groups the wrong way round.
  • Sorting manually by dragging and then wondering why new values appear in an odd place. Prefer sort-by-field.
  • Leaving Sheet 1. A named worksheet is easier to find on a dashboard.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. You drag Region to Rows and Sales to Columns. What does Tableau draw?

    A dimension on Rows with a measure on Columns defaults to a horizontal bar chart, and the measure is summed.
  2. 2. Where do you change SUM(Sales) to AVG(Sales)?

    Each measure pill has a Measure submenu that lists the aggregations.
  3. 3. Which sort option follows the data when a filter changes the values?

    Sort By Field is stored as a rule on the pill, so it is recalculated whenever the view changes.
  4. 4. What does the hint under a greyed-out Show Me chart tell you?

    The hint lists the required number of dimensions and measures for that chart type.

Summary

  • Build a chart by dragging a dimension and a measure to shelves, then add Color and Label from the Marks card.
  • Pill order decides nesting; Swap Rows and Columns flips the orientation.
  • Every measure has an aggregation you can change (Sum, Average, Count Distinct and more).
  • Sort by field so the sort keeps up with filters and new data.
  • Show Me suggests charts for the fields you select, and its hint explains what a chart needs.

Next: Connecting to data: files, servers and extracts