From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

How to search and sort

How to search and sort - Tableau Tutorial

From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Start my 1-month free trial

How to search and sort

“

- [Instructor] It's not uncommon for datasets to have thousands or millions of rows of data. But how do you find specific values in all of that? Tableau Prep has a couple of functions, both searching and sorting, that let you find an individual record in all of those values. In this example, we'll look at the demo flight July 2016 flow and first step, I'm going to add a clean step. We have our preview pane, and our results grid. Now, say for example, I want to know all of the flights that originated from Seattle. So, for that, I'm going to go to the origin city and I'm going to click on search. I can type in the name of the city, and it shows me that there are 3,343 flights that originated from Seattle. Now, I haven't filtered any of the data out, I'm just selecting this one. If I then click on Seattle, it then highlights in blue all of the flights from Seattle. So, for example, I can see that in California, 6% of the flights in California orginated in Seattle. If I think click on…

Contents