From the course: Complete Guide to Tableau for Data Scientists

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Solution: Analytics, part 2

Solution: Analytics, part 2

(upbeat music) - [Instructor] Okay, let's see what we can do with this. So, they love this box plot for what it gives them, but they've now decided they want to be able to look at any of these expenses, not just the two they originally told us. So we're going to need to make some changes to our data. Now, ideally I want to filter that's like a single dropdown that they can select, but I can't do it with the data in this way because my measures are measures not selectable dimensions. So I need to pivot this data. Trouble is I'm using this in other charts and that's definitely going to break them. So, first step, let's fix the data and then we'll fix the sheet. I think that will work. So let's edit our data source. Okay, so it's this expenses table that we're going to be changing. Let's have a little look at it. So I've got my date, and then I've got my calculation for the expenses date. Well, let's hide this 'cause I'm not interested in that date at the moment. So let's just hide that…

Contents