Skip to main content
Data Visualization and Interpretation

Tableau Interactivity: Parameters, Combined Fields, Sets, and Filtering

Published: 2026-08-11
Level: postgraduate
Audience: Postgraduate students in Data Visualization and Interpretation

7.1 Recap: Tableau Foundations and the Opening Quiz

7.1.1 What We Covered Before This Session

This session opens with a fast recap of everything the course has built so far, because the whole rest of the day leans on it — parameters, combined fields, sets, and filtering are all built on top of the vocabulary you already know.

The Tableau product family has many members — Tableau Server, Tableau Desktop, and Tableau on cloud among them. Desktop can be installed two ways: a 14-day trial version, or a one-year license that Tableau gives to students and anyone in academics. The very first step of any Tableau work is the data connection, which is also how every new project should start. There are file-based connections where we give a file — an Excel file or a text file — server-based connections where Tableau talks directly to server databases (roughly 80–90 different connections exist), and some safe data sources that ship ready to use.

Two connection modes matter for performance. A live connection keeps the data live, so the figures on the sheet refresh on the fly; that makes sense when we really need real-time numbers. When the data is huge and the purpose is analysis rather than real time, we can use an extract instead: Tableau takes a one-time dump of the data onto the laptop, and all the analysis runs against that local copy.

We also covered the six data types, and a feature called the data interpreter, which activates automatically whenever the data is not in a clean table format. In the demo it handled an Excel file with merged cells and even a PDF; you tick the checkbox, Tableau cleans the data as best it can, and then it gives you a report highlighting every change the data interpreter made. It is up to us to accept the cleaned version or stick to the original data. Once data is loaded, the view data option lets us glance through it, and we toured the Tableau visual interface: the cards, the pills, the show me tab, and the file menu. One naming detail that keeps coming up: fields are sometimes called pills, because once you place a field on one of the shelves, its size and shape are very close to a real pill, and the name stuck.

The two most important classification terms are dimensions and measures.

A dimension is a field that classifies the data — the qualitative labels like order id, location, or country name. A measure is a field that holds the data itself, meaning a numeric value you can compute with — age, temperature, profit — which can be averaged or summed.

The quick test is the name: a measure is something you can measure. If it makes sense to sum or average the values, it is a measure; if the values are labels that split rows into groups, it is a dimension. Sales, profit, and cost are measures; order id, location, and country name are dimensions.

We also learned a little about hierarchies, sorting, and grouping, and today the session returns to those topics briefly. The instructor deliberately does not expect anyone to memorize the interface; these things come naturally with use, and the recordings cover anything we miss.

Worked example — classifying the fields of Sample Superstore

A new data source lands on your desk with the following columns. Sort them into dimensions and measures.

Field name Example value Why it sorts that way
Order ID CA-2021-100111 A label that names each order — you would never add order ids together
Order Date 12/03/2021 A label that marks when — it groups rows by year, month, or day
Region West A label that groups rows by place
Category Furniture A label that groups rows by product family
Subcategory Chairs A label that groups rows by product type
Sales 261.96 A number you can sum — total sales for a region
Profit 41.91 A number you can sum or average — margin analysis
Quantity 2 A count you can sum — total items sold

The classification rule in one line: if you can sum or average the column, it is a measure; if it names or labels the rows, it is a dimension. So Order ID, Order Date, Region, Category, and Subcategory are dimensions, and Sales, Profit, and Quantity are measures.

Sense-check: put Region on rows and Sales on the sheet, and Tableau shows one sales total per region — the sum of every row in that region. You could not do that with Order ID, because summing ids would be meaningless.

7.1.2 The Opening Quiz: Questions and Answers

The recap quiz is a quick-fire round over the terms above. Nobody is being judged — it exists purely to refresh. Every exchange, with the reasoning given, is preserved here.

Q: The first question asks what a dimension in Tableau holds: does it hold a numerical value, a categorical value, a geographical value, or a calculated field? I guessed numerical.

A: A dimension holds a categorical value. The name gives it away: a measure is something you can measure, so measures are typically the numbers. Dimensions are the qualitative labels — order id, location, country name are dimensions. So the correct answer is the categorical value — the dimension holds a categorical value, and the measures hold the numbers.

Q: Which of the following actions can be performed using Tableau Desktop but not with Tableau Public: creating visualizations, sharing workbooks, connecting to local data sources, or publishing on a server?

A: Connecting to local data sources. Public will not allow you to connect to your local databases — for example an MS Access database that is listening on some IP address and port. You can create visualizations, share workbooks, and even publish on the server from Public, but local data source connections are blocked. That is the license boundary: the free Tableau Public lives on public cloud data, while Desktop owns the private, local connections.

Q: In the quiz, is a measure a categorical thing, a numerical value that can be aggregated, a geographic location, or a calculated field?

A: The correct answer is "a numerical value that can be aggregated." Sales, profit, and cost are measures — anything you can measure and then sum or average fits the name.

Q: What is the purpose of a data extract: to remove unwanted data from the visualization, to optimize performance by creating a local copy of the data, to export data to another application, or to import data from external sources?

A: Optimize performance by creating a local copy of the data. With an extract you work locally, so you do not need to go via the network every time, and you do not struggle with the performance of huge data. The extract is not about deleting rows — the full data still sits in the local copy.

Q: What is the purpose of Tableau Server: to develop data visualizations locally, to collaborate and share across the organization, to create data connections and extracts, or to perform complex data analysis?

A: To collaborate and share across the organization. That is the whole point of a server — anyone can connect to it and view what has been published, which is exactly why organizations buy it. Development happens in Desktop; the server is the sharing layer.

Q: Which feature in Tableau lets a user group related dimensions together: set, hierarchy, folder, or grouping?

A: Hierarchy is the correct answer, because the question says "related dimensions." A set can be made for anything, but a hierarchy is for fields that naturally go together — date has year, then quarter, then month; a location hierarchy has country, city, pin code. When you drag one field of the hierarchy, the related fields come along with it, and you can drill down through the levels without dragging each field separately. The keyword "related" is the clue: a set does not care about field relationships, a hierarchy is built exactly for them.

Q: Which of these is a method for sharing a Tableau workbook with users who do not have Tableau Desktop — exporting to PDF, or publishing to the server?

A: Publishing to the server. Exporting to PDF would not help the user. The whole purpose of the server is that people view the published work straight from there without needing individual Desktop licenses — one or two people develop, and everyone else in the organization consumes the dashboards on the enterprise server.

Exam note: A five-mark EC1 quiz has been enabled on the platform — roughly 20 or 25 questions — and the system mail went out, so check your inbox and tell classmates to finish it before the last date of 29 February. The quiz is the only piece of assessment before the final exam, and late completion triggers a lot of admin work, so do not let it slip.

7.2 Parameters

7.2.1 Why Parameters Exist

A parameter is a value we keep outside the visualization itself, so we do not have to hardcode numbers inside it. The instructor's analogy is code: when we write programs or keep files, we sometimes hold variables or numbers outside the code and pass them in as parameters, and the code changes automatically. Tableau has the same idea. On its own a parameter does nothing — it is an independent component that sits idle somewhere until a view or a filter uses it. Instead of editing a criterion every time the user's request changes, we create a parameter, link the visualization to it, and then changing the parameter changes the visualization for us.

Intuition: Think of a restaurant's specials board. The board itself does not cook anything — it is just a holder for the day's prices. When the price of the special changes, the kitchen rewrites the board, and every menu that points at it picks up the new number at once. A Tableau parameter is exactly that board: it sits outside the chart, holds one number, and every filter or calculation that points at it follows the number wherever it goes.

The analogy breaks in one place: a restaurant board is updated by staff, while a Tableau parameter is handed to the end user to slide themselves — that is the whole point, the user drives the chart without asking the developer.

Formalize: A parameter is a named, typed value with a fixed range that lives outside any worksheet. Formally, a parameter is defined by three things:

  • A name — the handle you will reference from filters and calculated fields (for example, Top N).
  • A data type — integer, float, string, date, or boolean; the type decides what values the control can carry.
  • A range — a minimum and a maximum with an optional step size, which bounds what the end user is allowed to pick (for example, minimum 1, maximum 10, step 1).

Until something references the parameter — a filter set to "use parameter," a calculated field, or a reference line — it stays inert. The parameter is the knob; the filter, field, or line is the machine the knob turns.

7.2.2 Creating a Parameter and Linking It to a Filter

The worked example starts with a plain view: sales of all subcategories, built by dragging subcategory and sales onto the sheet. The request changes to "show me top 10, not all," so we right-click and add a filter, choose top by field, and type 10. It works, but the moment someone asks for top 5 instead, we have to go back into the filter, edit the criteria, and reapply. That is the pain parameters remove.

Instead of typing the number, the filter dialog offers a "create a new parameter" option. We name the parameter, and give it a minimum of 1 and a maximum of 10 — the range the end user is allowed to pick from. Now the new parameter appears as an object we own. We edit the filter again, but this time we choose "use parameter" instead of typing a number, so the filter takes its value from the parameter. Finally we right-click the parameter and choose show parameter, which places a visible control on the sheet. From then on, dragging the control to 5 shows five bars, 6 shows six, 7 shows seven, and so on — the user can go all the way from 1 to 10, and both extremes come from the range we set when creating the parameter. Nothing in the filter dialog is touched again; the whole chart follows the parameter value.

Worked example — top 10 becomes any top N

The sheet shows subcategory-wise sales, with twelve subcategories in the data.

  1. Right-click the Subcategory field, choose Filter, open the Top tab, and set "Top 10 by Sales." The chart now shows the ten best-selling subcategories, and the eleventh and twelfth disappear.
  2. A colleague asks for the top 5. The hardcoded route: open the filter again, retype 10 → 5, reapply. Do this three times a day and the developer spends the day editing filters.
  3. The parameter route: open the same filter dialog, click Create a new parameter, name it Top N, set the data type to integer, minimum 1, maximum 10, step 1. The parameter now sits in the Data pane under its own section.
  4. Reopen the filter, choose Use Parameter, and pick Top N instead of the number 10.
  5. Right-click Top N in the Data pane and choose Show Parameter — a slider (or stepper) appears on the sheet.

Now the end user drags the control: at 3 the chart shows three bars, at 5 it shows five, at 10 it shows all ten. The developer never opens a filter dialog again; both extremes, 1 and 10, were fixed when the range was created.

Sense-check: the filter is no longer a fixed rule but a function of the parameter — the chart responds instantly to every position of the control, and the summary in the filter dialog still reports the rule in force, now written in terms of the parameter.

Comparison — hardcoded value versus parameter

Dimension Hardcoded number in the filter Parameter-driven filter
Who changes it The developer, through the filter dialog The end user, through the on-sheet control
Effort per change Open dialog, edit, reapply Drag the control
Range control None — any number can be typed Clamped to the defined min–max
Reuse across sheets Each sheet needs its own edit One parameter, shared everywhere
Dashboard feel Developer-mode Self-service and interactive

When to pick which: a one-off fixed view can keep a hardcoded number; any view the user is expected to interrogate ("top 5 versus top 10 today?") should be parameter-driven.

7.2.3 What Parameters Do for Dashboards

The real payoff shows up later, because dashboards are all about interaction. Every parameter we create appears in a shared list of params, and those params can be used inside filters anywhere. When we say show parameter, we hand the end user the control, and they can explore top 5 versus top 10 on their own. The instructor frames this as the direction of the whole course: user asks "show me top five" today, "show me top ten" tomorrow — with a parameter the user does it themselves, and the interactiveness of the dashboard grows without the developer rebuilding anything.

Visual intuition: picture the finished sheet — subcategory names running down the rows, sales bars extending to the right, and the parameter control (a slider with "1" and "10" at the ends) floating on the sheet. Slide the thumb toward 5 and, bar by bar, the chart trims down to the five tallest bars; slide to 10 and the rest of the bars reappear. The tallest bars never change order — only how many of them stay visible, which is the takeaway: the parameter controls the cutoff, not the ranking.

Pitfalls of parameters

  • Range too tight. Setting maximum 10 when the user will want top 15 blocks the request at the boundary; choose the range for the widest realistic question, not today's.
  • Created but never shown. A parameter that exists but has no visible control is invisible power — the user cannot touch it. Right-click and Show Parameter or place the control on the dashboard.
  • Created but never linked. A parameter with no filter or calculation using it changes nothing when dragged. The link ("use parameter") is what connects the knob to the chart.
  • Wrong data type. An integer parameter cannot take the value 5.5; a float parameter surprises filters expecting whole counts. Match the type to the field it feeds.

Recap: A parameter is a shared, ranged value stored outside the visualization; link it to a filter once, show the control, and the end user drives the chart — top 5 today, top 10 tomorrow, no rebuilding. This is the first step of the course's arc toward interactive, self-service dashboards.

Real-world & domain connection: parameter-driven top-N selectors are the most common dashboard control in business reporting — retail dashboards let a sales manager slide "top 10 stores" to "top 5 stores" before a weekly review, and finance teams reuse one parameter across every regional P&L sheet so a single control updates the whole workbook. In dashboard design terms, this is the shift from developer-built, fixed views to user-driven exploration: the visualization no longer answers one question, it hands the user the tool to ask their own.

7.3 Combined Fields

7.3.1 The Problem: Sorting Stays Inside the Groups

Sometimes we want two or more fields to behave as one. The demo builds a view of category and subcategory wise sales — a crosstab where category groups the subcategory rows. When we sort by sales from high to low, the sorting happens within the groups: the rows get sorted inside category and subcategory first, so the highest value overall in that view reads 320k, and each category block stays internally ordered. That is fine for browsing, but sometimes the user says, "I do not want the subgrouping — show me all the numbers sorted genuinely, top to bottom, across everything." That is the situation where we combine fields.

Intuition: a group-wise crosstab is like sorting each shelf of a library alphabetically — every shelf is tidy, but "the most popular book in the building" is still buried. Tableau's default sort respects the group boundaries, so the true champion never escapes its shelf. A combined field glues the shelves together into one list, so the numbers can compete honestly.

7.3.2 Combining Two Fields

To combine, right-click on one of the fields (category, for example), choose create, then combine fields, and add the second field (subcategory). Tableau collapses the two into a single combined field, and the hierarchy grouping is gone — category and subcategory now behave as one entity. Dragging the combined field in and sorting by sales sorts the values genuinely by number, regardless of which category a combination belongs to.

Worked example — category and subcategory, two fields

Start from the crosstab with Category on rows, Subcategory nested under it, and Sales as the numbers. When sorted descending, each category block is internally ordered — Furniture's best row, then Office Supplies' best row, and so on. The overall top value reads 320k only because it is the leader of its block, not the true maximum.

  1. Right-click Category, choose Create, then Combine Fields.
  2. Add Subcategory to the combination. Tableau forms one key per category–subcategory pair, for example "Furniture + Chairs."
  3. Drag the combined field onto rows and sort by Sales descending.

Now the sort ignores the category blocks and ranks every pair by its number: the top reads 330, with the furniture–chair combination second — while the grouped view had kept 320k at the top of its group, and the follow-up comparison reports the furniture–chair value as 328 before the combined sort overtook it.

Sense-check: in the grouped view 320k sat at the top by construction (it won its block); in the combined view the same rows are ranked purely by value, so a 330 pair can pass it — the row order is now the truth, not the hierarchy.

The difference is visible in the row order: the combined field treats "furniture + chair" as one key, so it can sit anywhere in the list based purely on its number.

7.3.3 Combining Three or More Fields

The same move works for three fields and more, and we can change the sequence of the fields inside the combination.

Worked example — adding region, three fields

Add Region to the story: build a crosstab of Category, Subcategory, and Region with Sales. In that grouped view the maximum is 101 — somewhere in the furniture rows — but finding it means reading the whole table yourself, because the sort only orders within each category and subcategory.

  1. Right-click the combined field from before, choose Edit, and add Region to the combination — or right-click Category and combine all three fields at once. Tableau builds one key per category–subcategory–region combination.
  2. Drag the three-way combined field onto rows and sort by Sales.

A single sort now ranks every combination: furniture in west chairs have the maximum sales, technology in east phones are second, and office supplies in south fasteners are the lowest — the fasteners are not moving at all.

Sense-check: the top combination's numbers (101 for furniture–west–chairs) beat every other triple in one pass, and the bottom triple (office supplies–south–fasteners) sits last, which a human would have to scan many rows to confirm by eye. Chairs are the most sellable item and phones follow, and the combined field tells us that without any manual scanning.

Visual intuition: picture the crosstab before combining — the row headers are indented in a tree (Furniture holding its subcategories, then Office Supplies holding its own), and the sales column bounces up and down as the group resets. After combining, the same rows become a single flat list: one unindented header per triple, sales falling steadily from 101 to the fasteners' low value, with no bumps where a new category begins. The flatness of the row headers is the visual signature that the sort is now genuine.

7.3.4 When Not to Combine

It matters not to over-correct. These group-wise crosstab views are not bad views — they are very useful when comparing region-wise or category-wise sales, and the instructor stresses that the combined field is for the cases where we genuinely need one flat, genuinely sorted list. Choose combine only when the grouped sort gets in the way; keep the grouped views for comparison work.

Scope and pitfalls of combined fields

  • Scope: combine when the question is "rank everything at once" — a single flat list sorted truly. Keep the grouped crosstab when the question is comparative — "how does each region's furniture do against its own subcategories?" The grouped view answers that directly; the combined view hides the structure it needs.
  • Pitfall — combining away useful structure. Once combined, the category–subcategory nesting disappears from the view; a stakeholder who wanted block comparisons will not find them. Keep a second sheet for the grouped view rather than destroying it.
  • Pitfall — confusing the key with the values. The combined field is one label built from other labels; it carries no sales number of its own. Sorting it still needs the measure (Sales) as the ranking field.
  • Pitfall — three fields, more rows. Each extra field multiplies the row count; with region added, a small crosstab can become a long list. Combine only the fields the question actually needs.

Recap: default sorts respect group boundaries; a combined field fuses two or more labels into one key so the sort ranks every pair or triple by its number — use it for flat, genuinely sorted lists, and keep the group-wise crosstab views for comparisons.

Real-world & domain connection: analysts combine fields when handing a "true top 20" to leadership — for example, ranking every product × store × region triple across a chain, or every country × business-line pair in a global P&L, so the biggest number genuinely surfaces instead of the biggest number per silo. It is the reporting handoff counterpart to exporting crosstabs: the flat list is what a decision maker reads top-to-bottom, and the grouped view is what an analyst compares column by column.

7.4 Sets

7.4.1 What a Set Is

A set is a hand-picked collection of members from a field, grouped together so Tableau always treats them as one unit. Unlike a hierarchy, which joins related fields at the field level, a set is not tied to field relationships — we can create a set out of anything, picking members randomly or by rules. Once a set exists, we can color by it, compare it against everything else, and reuse it in other sheets.

Intuition: a set is like a guest list at a party. The list does not care what the guests have in common — no profession, no address, no relationship required — it simply says "these people are in, everyone else is out." As long as a name is on the list, that person travels together: same table, same photos, same group updates. A Tableau set works the same way: the members stay one unit across every sheet until you change the list.

Comparison — set versus hierarchy

Dimension Set Hierarchy
What it holds Hand-picked members of one field Related fields (year → quarter → month)
Basis for membership Selection or a rule — anything Natural parent–child relationships
What you do with it Color, compare, filter, reuse across sheets Drill down level by level
Relationship to fields None — works on any field Requires fields that nest logically

When to pick which: a set answers "these specific members travel together"; a hierarchy answers "this field belongs inside that one."

Formalize: a set is defined by two parts — the membership (which values of the source field belong) and the source field (the field those values come from). Membership can be fixed, like an explicit list of members, or rule-driven, like "top five by sales," in which case Tableau re-evaluates the rule whenever the underlying data changes. On every sheet, the set behaves as a binary property of each row: in the set or out of the set, which is why it can drive color, filters, and comparisons so directly.

7.4.2 Creating a Set by Selection

The first demo starts with subcategory-wise sales sorted high to low. We want a few of those subcategories to travel together, so we drag the mouse over the bars we care about — Tableau highlights everything under the selection — right-click, and choose create set. Naming it my set finishes the job. Drop the set on color, and the selected members all get one color while everything else stays differentiated, so the set members jump out of the chart instantly.

Worked example — mouse selection route

The sheet shows sales by subcategory, twelve bars sorted high to low.

  1. Click and drag the mouse across the four or five bars you care about — Tableau highlights every bar under the selection.
  2. Right-click the highlighted bars, choose Create Set, and name it My Set.
  3. Drag My Set onto Color. The selected members — roughly four or five of the twelve subcategories — now share one color, while every other subcategory keeps its own.

The chart reads in one glance: the colored bars are the protagonists, the rest are the backdrop. Sense-check: the set members still sit at their original positions in the sort — the set changed their color, not their rank — which is exactly why comparing "us versus the rest" becomes instant.

7.4.3 Creating a Set Through the Dialog

The second route avoids the mouse: right-click a field, choose create set, and build the set from the dialog. The example defines a set that always contains table and chair together — whenever the data contains those two members, they belong to the set. Color by that set, and table and chair show as one group against the rest; the chart immediately tells us how this set is doing versus others. This dialog route is the one to use when the membership is a standing rule rather than whatever happens to be selected today.

Worked example — dialog route

  1. Right-click the Subcategory field, choose Create Set, and the dialog opens with a scrollable list of members.
  2. Tick Table and Chair only. The dialog also offers condition and top tabs for rule-based membership, but here the list is explicit.
  3. Name the set Tables and Chairs and drag it onto Color.

Every chart now colors table and chair as one unit against everything else — the pair travels together in every sheet that uses the set. Sense-check: drop the same set onto a second sheet's filter and both members filter together there too, which a manual two-value filter would not keep synchronized.

7.4.4 Turning a Set into a Top Group

A set does not have to be frozen. Editing a set opens the same dialog, where we can swap the fixed member list for a rule — for example, "always show the top five members of this group." Now the set is dynamic: it still works as one color-coded unit, but its membership is always whatever the top five happen to be. That keeps the story current as the data changes.

Worked example — editing a set into a dynamic top five

  1. Right-click the set in the Data pane and choose Edit Set — the same creation dialog reopens.
  2. Switch the membership from the fixed member list to the Top tab: "Top 5 by Sales."
  3. Close the dialog. The set now recomputes itself: today's top five subcategories are in the set; if next month's data reshuffles the ranking, the set membership follows the new top five automatically.

Sense-check: freeze and rule give the same answer today — the current top five — but they diverge tomorrow: the frozen set keeps last month's names, the dynamic set follows the data, which is the point of a set that must stay current.

7.4.5 A Real-world Set: Metros by GDP

Real-world: the instructor's example is state-wise GDP for all of India. With data on 20-plus states, comparing everything gets noisy, but the user only cares about the metros. We would select Delhi, Mumbai, Kolkata, and Bangalore and make a metro set; from then on that set always travels together in every comparison and every color coding, and the non-metros can be filtered away or kept as the contrast group. The same pattern generalizes to any product group, customer group, or region an organization cares about.

Visual intuition: picture a state-wise GDP bar chart, twenty-plus bars in a single color — the eye can spot the tallest few, but "how are the metros doing as a group?" takes a scan of every bar. Color the metro set, and four bars light up in one color while the rest stay muted: the comparison "metros versus the rest" now resolves before you finish looking at the chart. One color, one glance, one question answered.

7.4.6 Sets in Stories and Dashboards

Sets are where narratives start. When we build stories or dashboards, we often want to talk about specific things only — say, chairs and tables as the top four of the twelve items. A set gives us that focus: color the set, filter to the set, and every sheet in the dashboard knows which members are the protagonists. Any combination or permutation of members can become a set, which is exactly what makes sets flexible for visualization.

Pitfalls of sets

  • Frozen sets go stale. A set created by selection is a snapshot; new data with better performers never joins. Re-edit it, or convert membership to a top rule, when the set must stay current.
  • Accidental selection. Dragging the mouse across nearby bars can sweep in members you did not mean to pick — check the highlighted bars before right-clicking.
  • Set versus hierarchy confusion. A set is not for drilling down; it is for grouping specific members into one unit. Reaching for a set where a hierarchy is needed (or the reverse) is the classic mix-up.
  • Hidden reuse. A set lives in the Data pane, not just the sheet it was born on; forgetting that it is reusable across sheets duplicates work you have already done.

Recap: a set is a hand-picked (or rule-driven) group of members from one field that travels together as one unit — color it, filter it, reuse it in every sheet — and it is the natural building block of story and dashboard narratives.

Real-world & domain connection: segment sets are a standard pattern in organizational reporting — a customer-success team defines a "top accounts" set for every dashboard, a marketing team keeps a "hero products" set across all their campaign sheets, and the metro-set pattern (Delhi, Mumbai, Kolkata, Bangalore in state-wise GDP data) is exactly how analysts focus executive dashboards on the few states that matter instead of all twenty-plus. Sets are how a narrative picks its protagonists once, in one place, and every sheet follows.

7.5 Titles and Captions

7.5.1 Editing the Title

Every worksheet shows a title at the top, and by default that title comes from the sheet name — sheet 1, sheet 2, and so on. That default is only a starting point: double-click the title and it becomes editable. We can give the sheet any title that describes the graph, such as "subcategory wise sales," change alignment to center, make it bold, and increase the font size so the heading actually reads as a heading. Double-clicking again later still lets us change any of it.

Intuition: the default title is Tableau's stand-in — like a file named New Document before you save your essay. The sheet name tells Tableau where the work lives; the title tells the reader what the chart means. One is bookkeeping, the other is communication, and the double-click is the door between them.

7.5.2 Auto Fields and Formatting the Title

Beyond plain text, the title editor can insert auto fields — dynamic pieces that Tableau fills in for us. The demo inserts the workbook name, and then the data source name, so the title reads something like "Subcategory wise sales — data source: Sample Superstore"; page count is another option. We can remove any inserted field with a click, combine them with separators such as a colon, and set background colors if we want the title to stand out. For proper formatting there is a separate format title option on the right-hand side: it controls shading (the demo gives the title a light gray gradient background) and borders (a dark blue border around the title is one click away).

Worked example — building a dynamic title

  1. Double-click the title of the subcategory-wise sales sheet and replace "Sheet 1" with Subcategory wise sales.
  2. With the cursor in the title, choose Insert, then pick the Workbook Name — a gray token appears that Tableau fills in automatically.
  3. Insert the Data Source Name too, with a colon and space as separators. The title now renders as "Subcategory wise sales — data source: Sample Superstore."
  4. Open Format Title from the right-hand menu: apply a light gray gradient background, then add a dark blue border with one click.

Sense-check: rename the workbook or switch the data source, and the title updates itself — the inserted fields are alive, not typed text, which is what makes the title safe for reports that ship every month.

7.5.3 Captions: Show, Hide, Edit

A caption is the explanatory line that can sit under the title. Captions come from the worksheet menu: show caption toggles one on, and Tableau fills in a default caption automatically. Like the title, the caption can be double-clicked and edited — make the font bigger, center it, make it italic, change its color. Both elements can be hidden independently through the worksheet menu (don't show title / don't show caption), which is handy when the sheet is small or the graph explains itself, and both can be brought back the same way.

Worked example — caption on, caption styled

  1. Open the Worksheet menu and choose Show Caption. Tableau drops a default caption under the title — usually a sentence describing the view, generated from the fields on the shelves.
  2. Double-click the caption to edit it, for example to "Sales by subcategory across all regions."
  3. Select the caption text, center it, bump the font size up, and make it italic.

Sense-check: the caption and the title now read as a pair — title says what, caption says in one line — and hiding either through the same Worksheet menu costs nothing, so small sheets can drop the caption and keep the graph.

7.5.4 Resetting with Clear

Formatting is easy to overdo, and stakeholders will sometimes ask for the plain default back. The format title and format caption panels both include a clear button: one click removes every formatting choice — shading, border, font changes — and restores the original default appearance. Nothing is lost permanently, because the edits were only formatting, not data.

Pitfalls of titles and captions

  • Formatting overdone. Bold, colored, bordered, gradient — each choice seems small, but together they fight the graph for attention. The Clear button exists for exactly this: one click restores the default when the title outshines the data.
  • Default titles shipped by accident. Sending a report full of "Sheet 1, Sheet 2" headings reads as unfinished work; rename before exporting.
  • Static titles that drift. A typed title stays stale when the workbook is renamed or the data source changes — the insert auto fields route keeps the title honest.
  • Hidden and forgotten. Hiding the title or caption on a small sheet is fine; forgetting that you hid them confuses the next reader, and the same Worksheet menu is the way back.

Recap: the title comes from the sheet name but is fully editable, can carry live auto fields (workbook and data source), and is formatted separately; captions add an editable one-line explanation under it; and Clear restores the plain default whenever formatting goes too far.

Real-world & domain connection: titles are the first thing a stakeholder sees in a shared dashboard or a PDF export, so the demo habit — a descriptive title plus a live data-source label — is standard practice in organizations that ship recurring reports, where "which workbook, which data" must be verifiable at a glance even months later. The Clear button maps directly to the design principle that formatting should serve readability, not decorate it.

7.6 Exporting Worksheets

7.6.1 The Export Menu at a Glance

Tableau worksheets can leave Tableau in several formats. The export options are: print to PDF, export as image, export the data as an MDB file (Microsoft database), export the crosstab to Excel, and copy to the clipboard. Which one you pick depends on who is asking — a stakeholder wanting a static report, a colleague wanting the raw numbers, or a quick paste into a presentation.

Intuition: exporting is like choosing how to hand over a recipe — print it for the wall, send the ingredient list for someone else to cook with, or snap a photo for a quick message. The chart on screen is the cooked dish; each export option packages it differently for a different consumer.

7.6.2 Print to PDF

File, print to PDF asks whether we want the entire workbook or only the active sheet.

Worked example — multi-page PDF

  1. Choose File → Print to PDF.
  2. The dialog asks: Entire Workbook or Active Sheet. Pick the entire workbook — the demo's workbook holds four sheets.
  3. Confirm paper size, orientation (landscape or portrait), and whether to show the selection.
  4. The export produces a multi-page PDF with every sheet — in the demo, sheet one through sheet four appeared in order.

The default fit sometimes leaves sheets split awkwardly across pages; the fix is the fit setting (fit to width, fit to height), and with that the PDFs come out clean. Sense-check: one wide chart spread across two pages means the fit setting was left at default — set fit to width and the sheet lands on one page.

7.6.3 Export as Image

When the deliverable is a picture — an email, a report, a slide — worksheet, export, export as image saves the current sheet as an image file. The dialog asks whether to include all the elements on the sheet; confirming produces a standalone image of exactly what the sheet shows.

7.6.4 Export Data and Crosstab

Sometimes someone says, "give me the raw data, I will do my own numbers." Worksheet, export, data saves the underlying data as an MDB file — the Microsoft database format. Alternatively, export crosstab sends the sheet's aggregated numbers to Excel as a region-wise, category-wise table, so the recipient gets the crosstab we see on screen and can build their own calculations on top of it. The demo's crosstab came out as exactly the row-and-column numbers the sheet displayed.

Scope — which export fits which ask

  • PDF for the report: the finished visual, page-sized, for stakeholders and archives.
  • Image for the quick share: one picture for an email or a slide, no navigation, no raw numbers.
  • MDB for the analyst who wants everything: the full underlying data in Microsoft database format, for their own analysis.
  • Excel crosstab for the numbers-on-top-of-nothing: the aggregated table exactly as the sheet shows it, ready for further calculation in Excel.

7.6.5 Copy to the Clipboard

The clipboard route is the fastest. The demo chart was a region-wise sales view, colored by category, with category and sales shown as labels — the instructor built it in a few clicks: put region on columns (had it gone on rows, the regions would run vertically), put sales on the axis, then drag category onto color so each region's bar splits by category, and put category and sales on labels to show the numbers.

Worked example — chart to PowerPoint in ten seconds

  1. Drag Region onto Columns — region headers run across the top, and the bars group by region. (On Rows instead, the regions would run vertically, which changes the look of the final image.)
  2. Drag Sales onto Rows, so the axis measures total sales.
  3. Drag Category onto Color — each region's bar splits into stacked segments by category.
  4. Drag Category and Sales onto Label, so every segment shows its number.
  5. Read the chart: central is 500k, east is 670k, and inside central, technology contributes 170 while office supplies contribute 167.
  6. Choose Worksheet → Export → Data → Copy → Copy Image.
  7. Open PowerPoint and press Ctrl+V — the chart drops straight into the slide.

Sense-check: the pasted image shows exactly what the sheet showed — region bars, category colors, and the 500k/670k totals as labels — because the export copied the rendered chart, not a screenshot of the desktop around it. For a quick presentation note, that is the entire workflow.

Visual intuition: the copied chart reads as three side-by-side vertical bars, one per region, each bar split into stacked color segments with numbers on them — east is the tallest at 670k, central follows at 500k with its technology segment (170) and office supplies segment (167) labeled on the chart. The takeaway in one glance: the chart answers "which region sells the most, and what mix inside it?" without a single extra click.

Pitfalls of exporting

  • Ignoring the fit setting. A PDF with a chart amputated across two pages looks broken; set fit to width before exporting.
  • Exporting data when the ask was a picture. MDB/crosstab exports hand over numbers; an image hands over the view. Sending the wrong package confuses the recipient.
  • Copying the wrong thing. The Copy Image route copies the chart; copying the sheet's cells instead pastes text into the slide. Use the Export menu for the image.
  • Regions on the wrong shelf. Region on Rows flips the layout and can break the look of the exported image — build first, export after.

Recap: five export routes — PDF for reports, image for shares, MDB for raw data, Excel crosstab for the aggregated table, and copy-to-clipboard for instant slides — each one a different package of the same sheet, chosen by who is asking.

Real-world & domain connection: copy-image-to-clipboard (Ctrl+V into PowerPoint) is a standard quick-report workflow for sharing chart snapshots in meetings, while the crosstab-to-Excel and data-to-MDB routes are everyday reporting handoffs — analysts hand raw numbers to teams that do their own analysis, and the fit-settings habit keeps exported PDFs presentation-ready for stakeholders.

7.7 Metadata Management

7.7.1 Hiding and Unhiding Fields

The metadata pane holds every field in the data source, and part of managing it is keeping the pane tidy. Right-click a field and choose hide, and it disappears from the pane. Hidden fields are not gone — the show hidden fields option brings them back as grayed-out entries, and a right-click unhides them for good. This is useful when a data source has dozens of fields but a project only needs a handful.

Intuition: hiding a field is like moving a rarely used tool to the bottom drawer — it stays in the workshop, just out of the way. The field still exists in the data source and still works in any calculation that references it; hiding only cleans the shelf you look at.

7.7.2 Renaming Fields

Field names can be changed without touching the source data. Rename by single-clicking the field name, or through the small arrow at the bottom edge of the field chip. A clearer name — for example renaming a cryptic source column to something the business understands — makes every subsequent sheet easier to read.

7.7.3 Hierarchies

Hierarchies were part of the recap, and the demo builds one live. Drag one field over another when the fields are logically related — for example dragging city over country — and Tableau nests them into a hierarchy; more fields can be added under the hierarchy, and the sequence can be changed at any time. A hierarchy is built for drill-down: pull the hierarchy onto a shelf, and every related field comes along in one drag instead of being dragged separately, then we zoom into the data level by level — country, then region, then state, then city. Location is a hierarchy name, not a field: it will never appear in the source table, only as the grouping that owns the fields underneath it. Hierarchy members carry a distinct icon in the pane.

Worked example — building the Location hierarchy

  1. In the Data pane, drag City and drop it on Country. Tableau nests City under Country and names the pair — here, Location.
  2. Drag State and Region under the hierarchy as well; the sequence can be changed at any time by re-dragging members.
  3. Pull the Location hierarchy onto Rows. One drag brings Country, Region, State, and City onto the shelf together.
  4. Click the plus signs level by level to zoom: country totals, then region, then state, then city.

Sense-check: before the hierarchy, building the same four-level drill-down meant dragging four fields and rebuilding the view by hand; with the hierarchy, every related field came along in one drag, which is the whole point of the feature.

7.7.4 Folders and Searching

Folders organize fields into named groups in the pane. The key setup step: before creating a folder, first group the field listing by folders (the menu option that changes the pane's sort). Then right-click, create folder, give it a name, and drag fields under it. Folders shrink the visible list, and the search box at the top of the pane finds any field instantly even when the pane is crowded.

Pitfalls of metadata housekeeping

  • Hiding by accident, panicking by default. A hidden field is not deleted — show hidden fields brings it back grayed-out, and right-click unhides it for good.
  • Renaming inside Tableau vs renaming the source. The rename lives only in the workbook; the source column keeps its original name, which surprises people who later open the raw data expecting to find the new name.
  • Folding before grouping. Creating a folder before grouping the listing by folders leaves the pane's sort mode wrong, and the folder seems to go nowhere.
  • Hierarchy name confusion. A hierarchy's name is a container, not a field — it never appears in the source table, so nobody will find it there.

7.7.5 Calculated Fields

A calculated field is a new field we define with a formula over the existing fields. Right-click anywhere in the pane, choose create calculated field, and the editor opens. The left-hand list shows the fields, and the function list is complete — every function comes with its syntax, a plain-language description of what it does, and the parameters it needs, so the editor doubles as documentation. Aggregations like average, minimum, and maximum are there; string functions can convert a passed string into its ASCII codes; date functions support date addition, date difference, a date parser, and a date day function that returns the specific day for any date passed to it. The editor validates the syntax live and shows an error when the formula is wrong, so a bad formula has to be fixed before it can be used.

The demo defines the cost price: take sales and subtract profit.

The verbal description of the formula is simple: "the sum of the difference between the sales and the profit." Per record, the difference gives the cost price for that product id — placed product-wise on a sheet, Tableau shows the sum of the difference for every product id at record level. Once created, the calculated field appears in the field list and behaves like any regular field inside further calculations and reports.

Worked example — cost price with real numbers

The source has two order rows for product id P-1001:

Product id Sales Profit Cost price per row (Sales − Profit)
P-1001 300 50 250
P-1001 200 30 170
P-1002 500 80 420
  1. Right-click the Data pane, choose Create Calculated Field, and enter:

  1. The editor validates the syntax live; the field appears in the field list as Cost price.
  2. Drag Product id and the new Cost price field onto the sheet. Tableau computes per record and then sums per product id:

Sense-check: because subtraction is linear, the sum of the per-row differences equals the difference of the sums — total sales 500 minus total profit 80 is 420, the same number the sheet shows. And a profit greater than sales is impossible for a normal sale, since profit is defined as sales minus cost, so cost price stays non-negative.

7.7.6 Data Preparation: At the Source or in Tableau

There are two philosophies of preparation, and both are valid. Option one: prepare the data at the source before it ever reaches Tableau — do all the calculations in the database or the ETL tool, and use Tableau purely for drag-and-drop. Option two: bring the data in and handle the logic inside Tableau with calculated fields and the functions above. Real projects usually do some of both — you cannot always take data preparation to its logical end at the source, so Tableau's calculated fields cover the rest. Fields can be added, edited, and deleted freely, and the values flow into sheets like any source field.

Recap: the metadata pane is the housekeeping layer — hide, rename, nest into hierarchies, file into folders, and search; calculated fields add new fields defined by formulas (cost price = sales − profit), validated live; and preparation can live at the source or inside Tableau, with real projects mixing both.

Real-world & domain connection: the source-versus-Tableau choice mirrors how analytics teams actually split work — data warehouses and ETL pipelines (Extract, Transform, Load) compute the heavy, company-wide logic once for everyone, while analysts keep project-specific formulas like cost price as calculated fields inside Tableau so they can iterate without waiting on the warehouse team. Calculated fields are also where business logic like margins, growth rates, and day-of-week flags live in daily reporting, because the formula is documented, reusable, and shared with every sheet that references it.

7.8 Filtering the Data

7.8.1 Why Filtering Is a Dashboard Skill

So far the sheets have shown everything the drag produced, with no way to narrow it. Filtering is the mechanism for narrowing, and the instructor's framing is explicit: filters are a core component for dashboards, because dashboards must let the end user be flexible and explore on their own. "Show me only the west, compare east with west" — that is what filtering will make possible. Every technique here carries over into the dashboard sheets later.

Intuition: a dashboard without filters is a book you may only read cover to cover — the reader cannot jump to the chapter that matters. Filters turn the book into a table of contents: the user decides what stays in front of them and what steps aside, and that freedom is what makes a dashboard self-service.

7.8.2 The Filter Shelf and the Filter Dialog

The most direct route is the filter shelf. Drag the field we want to filter on into the filter shelf, and the filter dialog opens automatically. The dialog has four tabs — General, Wildcard, Condition, and Top — and we are not forced to use them all: the summary at the bottom tells us exactly what combination is active, and each tab handles a different style of rule.

Formalize — the four filter tabs:

Tab Rule it builds Example
General Pick values by hand, or exclude them "Keep only East and West"
Wildcard Match values by pattern "Anything ending with s"
Condition Keep values passing a numeric test "Sales ≥ 0"
Top Cap the list by rank "Top 10 by Sales"

The tabs combine freely in one filter — for instance, values picked on General, a pattern on Wildcard, a numeric rule on Condition, and a rank cap on Top — and the dialog's summary line lists every rule that is in force, which is the honest record of what the view shows and why.

7.8.3 The General Tab

The General tab is the default. It lists the field's values with checkboxes: select all, select none, pick individual values, or invert the selection with exclude.

Worked example — selecting and excluding regions

The data has four regions: Central, East, South, West.

  1. Drag Region onto the filter shelf. The General tab lists the four values with checkboxes.
  2. Tick East and West — the selection now covers two of the four values.
  3. Click Exclude. Whatever is selected gets struck out and is removed from the view: with east and west excluded, only central and south remain.

The summary line keeps us honest: filtering region with two of the four values selected, no wildcard applied, no condition, no top. Any filter placed this way also produces a small legend on the sheet so we always know what we are looking at. Sense-check: exclude inverts the checkboxes — it says "these, and nothing else, go away" — so the view keeps exactly the values that were not ticked.

7.8.4 The Wildcard Tab

Wildcard filtering matches values by pattern instead of picking them one by one: contains, starts with, ends with, or exactly matches, with a box to type the pattern.

Worked example — subcategories ending with s

  1. Drag Subcategory onto the filter shelf and open the Wildcard tab.
  2. Choose Ends With and type s in the pattern box.
  3. Every matching subcategory remains — for example Copiers (which ends with s) — while every other subcategory drops out of the view.

Two properties to remember: the wildcard is case sensitive, so a lower-case a qualifies nothing when the values start with a capital letter — and it supports negation too (not starts with), which works just like exclude at the pattern level. Sense-check: the same dialog with "starts with A" and capital A finds Art, while "starts with a" finds nothing — the case of the pattern must match the case of the values.

Scope of wildcard filters

  • Case sensitivity is the trap. Wildcard matching compares exact characters; a pattern typed in lower case silently matches nothing against capital-letter values. The professor's flag: a lower-case a qualifies nothing.
  • Pattern scope. Contains/Starts With/Ends With/Exactly all operate on the whole value, not words inside it — "ends with s" keeps every value whose final character is s.
  • Negation is available. "Not starts with" filters like exclude at the pattern level, keeping everything that does not match.

7.8.5 The Top and Condition Tabs

The Top tab limits by rank: show me the top 10 subcategories by sales, or top 5 by sales, with the ranking based on a chosen field and aggregation. The Condition tab limits by a numeric rule: for example, keep only values where sales is greater than or equal to zero. All four tabs can be combined in one filter — select values on General, pattern-match on Wildcard, keep the ones over zero on Condition, and cap the list at the top 10 by sales on Top — and the summary line lists every rule that is in force.

Worked example — one filter, all four tabs

  1. On the General tab, tick the regions you want to compare.
  2. On the Wildcard tab, add "ends with s" for the subcategories.
  3. On the Condition tab, set Sales ≥ 0 so no negative-sales rows survive.
  4. On the Top tab, cap the result at Top 10 by Sales.

The summary line now reads every rule at once, and the view shows exactly the intersection: matching values, over zero, top ten. Sense-check: each tab narrows the same pipeline, so the final view is the intersection of all four rules — remove one tab and more rows reappear.

7.8.6 Filtering by Date

Date fields get their own treatment. Dropping order date onto the filter shelf offers several date-specific modes.

Worked example — comparing the first and the last year

  1. Drag Order Date onto the filter shelf. The dialog offers date-specific modes instead of the plain tabs.
  2. Pick Exact Years and select only 2018 and 2021 — the first and the last year of the four in the data — to compare the two ends.
  3. The sheet now shows sales only for 2018 and 2021. Removing the filter brings all four years back.

Alternatively, choose a Range of Dates, and Tableau fills in the first and the latest date automatically so we only adjust the ends; a Relative Date option is available too (rolling windows like "the last 7 days"), and there is a year-wise filter as well. Sense-check: exact years answer "fixed endpoints" questions, while range and relative dates answer "everything between" and "always the recent window" questions — so date filters support both the fixed comparison and the living, rolling comparison.

7.8.7 Interactive Filters: Show Filter

The filter shelf route works, but every change happens inside a dialog, which is a developer-mode workflow. For the end user, right-click any field and choose show filter instead: the field appears as a filter control on the right-hand side of the sheet, fully interactive. No dialog, no navigation — click values and the view updates. The control's style is configurable from the same menu: single value list (radio buttons, one at a time), single value dropdown, multiple value dropdown, slider (best for date ranges and number ranges), wildcard match, and the checkbox list.

Worked example — interactive category control

  1. Right-click Category on the sheet and choose Show Filter. A control appears on the right-hand side — no filter shelf involved.
  2. From the control's menu, cycle the style through Single Value List (radio buttons — one value at a time), Single Value Dropdown, and Slider just to see the options.
  3. Add Order Date as a second interactive filter — a slider over the years 2018 to 2021 where moving the dot changes the data on the sheet.

Multiple interactive filters can sit on one sheet at the same time. Sense-check: the radio-button list answers "which single category"; the slider answers "which time window" — the style matches the question the control is meant to answer.

7.8.8 Linking Filters: Show Only Relevant Values

With two filters on the sheet — category at the top and subcategory below — the pair can be linked. Right-click the lower filter and tick show only relevant values, and Tableau automatically filters the subcategory list to whatever belongs to the selected category: choosing furniture leaves only the furniture subcategories, choosing office supplies leaves only its own. The demo confirms the behavior — picking accessories only works under technology, and the two filters stay synchronized. This linking is precisely what dashboards need: one selection should filter the next, and if there is a third level, the third should follow the second.

Worked example — furniture narrows the list

  1. Put Category as a filter control at the top and Subcategory below it.
  2. Right-click the subcategory control and tick Show Only Relevant Values.
  3. Select Furniture in the category control — the subcategory list collapses to the furniture subcategories only. Select Office Supplies, and the list swaps to its own members.

Sense-check: before linking, both lists show every value no matter what; after linking, the lower list always agrees with the upper selection — one filter updates the second, and a third level would follow the second, which is the cascade dashboards are built on.

7.8.9 Filtering by Headers

Headers filter directly on the chart itself. With subcategory-wise sales on the sheet, double-click the accessories header and everything else vanishes — only accessories remains. Removing the filter brings the full list back. For several values at once, multi-select the headers (for example accessories, copier, and storage), right-click, and choose keep only — exactly those three stay and the rest go. Any chart linked to the same field updates to the same selection. No filter shelf, no dialog: just click on the values you care about.

Worked example — header filtering

  1. With subcategory-wise sales on the sheet, double-click the Accessories header — every other bar vanishes; only accessories remains. Right-click and Remove to bring the full list back.
  2. To keep several values: multi-select the Accessories, Copier, and Storage headers (Ctrl-click each), right-click, and choose Keep Only. Exactly those three stay and the rest go.

Sense-check: the double-click is a one-value filter and the multi-select keep only is a many-value filter — both operate on the chart itself, so any chart linked to the same field updates to the same selection without a single dialog.

7.8.10 Filtering by Legends

Wherever a legend exists, it filters too. In a chart colored by category, clicking the office supplies legend entry zooms the view to office supplies only; selecting two entries and choosing keep only keeps exactly those two; choosing exclude removes the clicked entries and keeps the rest. The demo does all three against the category legend — click, keep only, exclude — and clears back to full data with the remove option. Legends behave like header filters for the color dimension.

Worked example — legend filtering

  1. On a chart colored by Category, click the Office Supplies legend entry — the view zooms to office supplies only.
  2. Select two legend entries and choose Keep Only — exactly those two categories remain.
  3. Select Office Supplies and choose Exclude — office supplies disappears and the other categories stay.
  4. Use Remove (or clear) to bring the full data back.

Sense-check: the legend is the color dimension's header — click one entry, keep only a selection, or exclude entries, and the chart narrows instantly, mirroring header filtering without touching the shelves.

7.8.11 Summary of Filtering

Five routes, one goal. Filter shelf: drag the field up and pick values in the dialog. Interactive filters: right-click, show filter, and the control lives on the sheet with multiple styles. Show only relevant values: link stacked filters so one updates the next. Headers: double-click one value or multi-select and keep only. Legends: click, keep only, or exclude on the color legend. All five feed the same end: the user zooms into what interests them, hides what does not, and makes the decision making interesting. That is the interactiveness that dashboards are built to deliver, and each of these techniques is exactly the piece a dashboard will later assemble.

Recap — the five routes at a glance:

Route How Best for
Filter shelf Drag field up, pick in the dialog (General/Wildcard/Condition/Top) Precise developer-built rules, date modes
Interactive filter Right-click, Show Filter; styles from radio list to slider Handing control to the end user
Show only relevant values Link stacked filters so one updates the next Cascading dashboard filters
Headers Double-click one value, or multi-select and Keep Only Fast on-chart narrowing
Legends Click, Keep Only, or Exclude on the color legend Filtering by the color dimension

Every route lets the user zoom into what interests them and hide what does not — that is the interactiveness dashboards are built to deliver, and each technique is a piece the dashboard will later assemble.

7.8.12 Exam-Focused Q&A

The session ends with a question about the exam, and the answer shapes how to study.

Q: The sessions are so practical, but the exams are still theoretical. What kind of questions will we be giving in the exams, and how should we prepare?

A: There is no practical exam. Expect conceptual, case-study based questions: for a given scenario, what visualization would you choose, and why; what are the key things for dashboarding; what should we avoid. The easier part of the exam is exactly this conceptual base — a case study where you decide what your visualization would be and what the prerequisites are.

Exam note: the final exam is theoretical and conceptual — practice arguing choices (which visualization for which scenario, what dashboards need, what to avoid, what the prerequisites are) rather than memorizing clicks. Filtering is expected to matter in the dashboard case study: the five routes and the idea that a dashboard should let the user explore on their own.

Real-world & domain connection: interactive filtering with show only relevant values is what makes organizational dashboards self-service — one filter cascades through every sheet, so a sales manager can drill from region to subcategory without a developer. In dashboard design terms this is the analytical-dashboard pattern: strategic dashboards simply display, while analytical dashboards hand the user the controls — filters, drill-downs, and cascading selections — so the user explores causes, not just snapshots.

Exam Guidance Summary

The session's exam-relevant material, gathered in one place.

The EC1 quiz — five marks, fixed deadline

  • The EC1 quiz is enabled and carries five marks with roughly 20 or 25 questions. The system mail went out, and the last date is 29 February — check with classmates so nobody misses it, because late completion triggers a lot of admin work.

The final exam — conceptual, not practical

  • The final exam is theoretical, not practical. Question types are conceptual and case-study based: choose the right visualization for a scenario, state the key things for dashboarding, explain what to avoid, and list the prerequisites for a given case. Preparation means understanding concepts and being able to argue a visualization choice, not memorizing clicks.

Quiz answers worth keeping in mind

Question Answer to remember
What does a dimension hold? A categorical value; measures hold the numbers
Desktop vs Public Tableau Public blocks local data source connections
What is a measure? A numerical value that can be aggregated
Purpose of a data extract Optimize performance with a local copy of the data
Purpose of Tableau Server Collaborate and share across the organization
Grouping related dimensions The hierarchy feature groups related dimensions
Sharing with users who lack Desktop Publish to the server, not PDF export

Dashboard case study

  • Expect filtering to matter in the dashboard case study: the five routes (filter shelf, interactive filters, relevant values linking, headers, legends) and the idea that a dashboard should let the user explore on their own — one selection cascades, every chart updates together, and the end user drives the analysis without a developer.

Key Industry Applications

The real-world patterns from this session, in one place.

  • Tableau acquisition in the field: Tableau Desktop's two acquisition paths matter in practice — a 14-day trial for quick evaluation and the one-year academic license for students — and Tableau Server is how enterprises let one or two developers publish for the whole organization while everyone else consumes the dashboards.
  • Live versus extract in real workloads: live connections are used where figures must be on the fly (real-time dashboards), while extracts — a one-time local dump — are the standard choice for analysis workloads over huge data, because analysis copies avoid network latency.
  • The data interpreter against messy exports: the data interpreter handles messy source files such as merged-cell Excel sheets and PDFs, which is a constant real-world pain when raw exports come from other departments.
  • Segment sets in reporting: the metro set example — a set of Delhi, Mumbai, Kolkata, and Bangalore in state-wise GDP data — shows the pattern of business segment sets, which are used to focus comparisons and color coding in reporting.
  • Parameters as user-driven controls: parameters are the mechanism behind user-driven report controls — the same idea as passing variables into code — and they appear in dashboards as the top-N selectors that business users touch daily.
  • Reporting handoffs: combining fields into a single key, and exporting crosstabs to Excel or data to MDB, are everyday reporting handoffs: analysts hand raw numbers to teams that do their own analysis.
  • Self-service dashboards: interactive filtering with show only relevant values is what makes organizational dashboards self-service — one filter cascades through every sheet, so a sales manager can drill from region to subcategory without a developer.
  • Quick-share workflow: copy-image-to-clipboard (Ctrl+V into PowerPoint) is a standard quick-report workflow for sharing chart snapshots in meetings.

DVI Lecture 7 notes · Tableau Interactivity: Parameters, Combined Fields, Sets, and Filtering

Data Visualization and Interpretation· postgraduate· 2026-08-11

Sections Breakdown

17.1 Recap: Tableau Foundations and the Opening Quiz

The Tableau product family, install routes, live versus extract connections, dimensions versus measures, and the seven-question opening quiz with full corrections.

27.2 Parameters

Why parameters exist, how to create one and link it to a filter, and what they do for dashboards.

37.3 Combined Fields

Combining two or more fields into one key so a sort ranks every combination genuinely by its number.

47.4 Sets

Hand-picked or rule-driven member collections that travel together for coloring, filtering, and reuse.

57.5 Titles and Captions

Editing titles, inserting live auto fields, captions, formatting, and the Clear reset.

67.6 Exporting Worksheets

The five export routes: PDF, image, MDB data, Excel crosstab, and copy-to-clipboard.

77.7 Metadata Management

Hiding and renaming fields, hierarchies, folders and searching, calculated fields, and source-versus-Tableau preparation.

87.8 Filtering the Data

The filter shelf and its four tabs, date filtering, interactive filters, relevant-value linking, header and legend filtering.

9Exam Guidance Summary

The EC1 quiz deadline, the conceptual final exam format, quiz answers worth keeping, and the dashboard case study.

10Key Industry Applications

Real-world patterns: server publishing, extracts, the data interpreter, segment sets, parameters, reporting handoffs, self-service dashboards, and quick-share workflows.

Postgraduate students in Data Visualization and Interpretation

Exam Revision Notes

Below is the distilled, exam-ready core. Every entry comes from the full explanation above. Use this section for rapid review; return to the main notes when a point needs more context.

Recap: Tableau Foundations and the Opening Quiz

Must-know: Dimensions hold categorical labels; measures are numerical values that can be aggregated. Tableau Public blocks local data source connections; Tableau Server exists to share across the organization; a hierarchy groups related dimensions for drill-down; extracts optimize performance with a local copy.

⚠️ Top pitfall: Calling a dimension numerical — the name test is: if you can sum or average it, it is a measure; if it labels the rows, it is a dimension.

Self-check: Why is Tableau Public unable to connect to a local MS Access database while Desktop can?

Connects to: 7.7

Parameters

Must-know: A parameter is a named, typed value with a min–max range stored outside the view; a filter set to 'use parameter' follows it, and 'show parameter' hands the control to the user so top-N questions need no developer.

⚠️ Top pitfall: Creating a parameter but never linking it to a filter — dragging the control changes nothing until something references it.

Self-check: What are the three defining properties of a parameter, and which one bounds what the end user can pick?

Connects to: 7.1, 7.8

Combined Fields

Must-know: A combined field merges two or more fields into one key, removing the group nesting so a sort ranks every combination by its number; use it only when a flat genuinely sorted list is needed, and keep group-wise crosstabs for comparisons.

⚠️ Top pitfall: Assuming the default sort ranks everything — it sorts within each group, so the overall maximum can hide at the top of its block until fields are combined.

Self-check: In the three-field demo, which combination leads and which is lowest after combining category, subcategory, and region?

Connects to: 7.1, 7.4

Sets

Must-know: A set is a collection of members from one field — fixed by selection or dynamic by rule (e.g., top five) — treated as one unit across sheets; distinct from a hierarchy because it is not tied to field relationships.

⚠️ Top pitfall: Leaving a selection-based set frozen: membership never updates when the data changes, so the story goes stale until the set is edited or converted to a rule.

Self-check: Why would you build the metro set with the dialog rule tab rather than a frozen list, and what does 'top five by sales' do when the data changes?

Connects to: 7.1, 7.3

Titles and Captions

Must-know: Double-click edits any title or caption; auto fields (workbook name, data source name) keep titles live; format title/caption control shading and borders; Clear wipes formatting back to the default without touching data.

⚠️ Top pitfall: Over-formatting the title until it competes with the graph — Clear restores the default in one click.

Self-check: Why would you insert the data source name as an auto field rather than typing it?

Connects to: 7.6, 7.7

Exporting Worksheets

Must-know: The five export options: print to PDF (workbook or active sheet, with fit settings), export as image, export data to MDB, export crosstab to Excel, and copy image to clipboard for a direct Ctrl+V into slides.

⚠️ Top pitfall: Leaving the PDF fit setting at default, which splits wide sheets awkwardly across pages.

Self-check: How does the clipboard chart in the demo display central and east, and what numbers label the technology and office supplies segments inside central?

Connects to: 7.5, 7.7

Metadata Management

Must-know: Calculated fields define new fields by formula — cost price = sales − profit per record, summed per product id — and because subtraction is linear, the sum of the differences equals the difference of the sums.

⚠️ Top pitfall: Renaming a field inside Tableau and expecting the source column to change too — the rename lives only in the workbook.

Self-check: For product P-1001 with rows (300, 50) and (200, 30), what cost price does the calculated field show, and why does it equal total sales minus total profit?

Connects to: 7.1, 7.6

Filtering the Data

Must-know: Five filtering routes: filter shelf (General/Wildcard/Condition/Top tabs), interactive show-filter controls with configurable styles, show only relevant values to link stacked filters, header filtering by double-click or multi-select keep only, and legend filtering by click/keep only/exclude.

⚠️ Top pitfall: Wildcard filters are case sensitive — a lower-case pattern matches nothing against capital-letter values.

Self-check: Which filter routes operate directly on the chart itself without any dialog, and how does 'show only relevant values' change a stacked filter pair?

Connects to: 7.1, 7.2

Exam Guidance Summary

Must-know: The exam is conceptual and case-study based — choose the right visualization for a scenario, key dashboarding principles, what to avoid, prerequisites. The EC1 quiz carries five marks and closes 29 February.

⚠️ Top pitfall: Preparing by memorizing clicks when the exam asks for argued visualization choices.

Self-check: Which features does Tableau Public block compared with Desktop, and which feature groups related dimensions?

Connects to: 7.1, 7.8

Key Industry Applications

Must-know: Parameters drive user-facing top-N selectors; sets focus comparisons on business segments; show only relevant values makes dashboards self-service; extracts avoid network latency for analysis workloads.

Self-check: Why do analysis workloads over huge data prefer an extract over a live connection?

Connects to: 7.2, 7.4, 7.8

Was this lecture useful?

Loading comments…
🤖

BitsNotes AI Assistant

Subject Notes Assistant

Configure AI Chat

Choose how to access the chatbot
Have your own API key?

Switch to "Bring Your Own Key" tab above for unlimited access with any OpenAI-compatible provider.

🔑 Enter API key above to fetch live models from provider, or enter model name manually.
OpenAI-Compatible API Support

Choose any provider preset (Gemini, DeepSeek, Kimi, GLM, MiniMax, Qwen, OpenAI, Groq, Ollama, etc.) or enter a custom endpoint URL.

Security & Privacy First

Your API key is sent directly from your browser to your specified provider. BitsNotes servers never store or see your key.