Book Image

Learning Tableau 2022 - Fifth Edition

By : Joshua N. Milligan
Book Image

Learning Tableau 2022 - Fifth Edition

By: Joshua N. Milligan

Overview of this book

Learning Tableau 2022 helps you get started with Tableau and data visualization, but it does more than just cover the basic principles. It helps you understand how to analyze and communicate data visually, and articulate data stories using advanced features. This new edition is updated with Tableau’s latest features, such as dashboard extensions, Explain Data, and integration with CRM Analytics (Einstein Analytics), which will help you harness the full potential of artificial intelligence (AI) and predictive modeling in Tableau. After an exploration of the core principles, this book will teach you how to use table and level of detail calculations to extend and alter default visualizations, build interactive dashboards, and master the art of telling stories with data. You’ll learn about visual statistical analytics and create different types of static and animated visualizations and dashboards for rich user experiences. We then move on to interlinking different data sources with Tableau’s Data Model capabilities, along with maps and geospatial visualization. You will further use Tableau Prep Builder’s ability to efficiently clean and structure data. By the end of this book, you will be proficient in implementing the powerful features of Tableau 2022 to improve the business intelligence insights you can extract from your data.
Table of Contents (20 chapters)
18
Other Books You May Enjoy
19
Index

Using sheet swapping to change views on a dashboard

Let’s consider a simple example with a view showing Profit by Department and Category with a Department quick filter.

The dashboard has been formatted (from the menu, select Format | Dashboard) with gray shading to help us see the effect:

Figure 11.8: A demonstration of hiding a sheet in a dashboard

Observe how filtering out all departments results in a blank view. The title remains which prevents the view from collapsing. We’ll remove titles in the next example to complete the sheet swapping.

In order to swap two different sheets, we simply take advantage of the collapsing behavior along with the properties of layout containers. We’ll start by creating two different views filtered through a parameter and a calculated field. The parameter will allow us to determine which sheet is shown. Perform the following steps:

  1. Create an integer parameter named Show Sheet with a list of String...