Book Image

Tableau 10 Business Intelligence Cookbook

By : Donabel Santos, Paul Banoub
Book Image

Tableau 10 Business Intelligence Cookbook

By: Donabel Santos, Paul Banoub

Overview of this book

Tableau is a software tool that can speed up data analysis through its rich visualization capabilities, and help uncover insights for better and smarter decision making. This book is for the business, technology, data and analytics professionals who use and analyze data and data-driven approaches to support business operations and strategic initiatives in their organizations. This book provides easy-to-follow recipes to get the reader up and running with Tableau 10, and covers basic to advanced use cases and scenarios. The book starts with building basic charts in Tableau and moves on to building more complex charts by incorporating different Tableau features and interactivity components. There is an entire chapter dedicated to dashboard techniques and best practices. A number of recipes specifically for geospatial visualization, analytics, and data preparation are also covered. By the end of this book, you’ll have gained confidence and competence to analyze and communicate data and insights more efficiently and effectively by creating compelling interactive charts, dashboards, and stories in Tableau.
Table of Contents (17 chapters)
Tableau 10 Business Intelligence Cookbook
About the Author
About the Reviewer

Dynamically displaying and sorting measures

In this recipe, we will walk through the strategy to display and sort measures based on user selection.

Getting ready

To follow this recipe, open B05527_03 – STARTER.twbx. Use the worksheet called Dynamic Measure Display and Sort, and connect to the MasterTable (FlooddataMastListrev) data source.

How to do it…

The following are the steps to create a chart that enables displaying and sorting measures through a parameter:

  1. Right-click the arrow beside the Dimensions section in the side bar, and select Create Parameter.

  2. Create a string parameter called Sort by with the following settings:

  3. Show the parameter control for Sort by. You can do this by right-clicking on the parameter, and selecting Show Parameter Control.

  4. Create another parameter called Sort direction with the following settings:

  5. Show the Sort direction parameter control.

  6. Create a calculated field called Chosen Sort by with the following formula:

  7. Create another calculated field called Chosen Sort by...