WEBVTT 00:00.000 --> 00:10.000 All right, so now both sheets look exactly the same, but the buttons actually click to different pages. 00:10.000 --> 00:22.000 I'm going to take this out and I'm going to take this out and I'm going to bring in some other variations. 00:23.000 --> 00:30.000 Oh no, that looks like it messed up. I'm going to undo. It's fine. I'm going to bring in something first before I. 00:34.000 --> 00:36.000 Let's bring in this. 00:37.000 --> 00:42.000 Okay, that looks interesting and let's bring in a text table. 00:43.000 --> 00:52.000 And then I'm going to delete this and now I have my information here. Here I have my buttons. 00:52.000 --> 01:02.000 I'm going to click this. Hey, look at that. It automatically changes and so I can use this to navigate information within the dashboard. 01:03.000 --> 01:09.000 A couple of tricks. 01:09.000 --> 01:29.000 If I go over here, I can have this control both worksheets, just like in a pivot table where you have multiple pivot tables and you want to be able to use something that looks like a slicer. 01:29.000 --> 01:41.000 If I want to see Kelly Williams sales for accessories and all these sub products, I could just click on her and have it act as a filter. Right now if I do that, nothing happens. 01:41.000 --> 01:48.000 So what do you do to make that happen? You click here and you want to choose the option for filters. 01:49.000 --> 01:58.000 Let's see, this is not the option I'm looking for. 01:58.000 --> 02:05.000 I'll make sure I'm on the right sheet filters. 02:05.000 --> 02:17.000 There's a couple of ways to do this here, use as filter. That's what I wanted to do. 02:17.000 --> 02:23.000 Now, all right, I'm not seeing the option I'm looking for. 02:23.000 --> 02:35.000 So I'm going to have to, oh, I'm using the wrong object. I need to have an object that already has a filter. 02:35.000 --> 02:43.000 Now, if I want to do uses filter, I can just click this icon. Now it's acting as a filter for both sheets. 02:43.000 --> 02:49.000 So if I want to see Kelly Williams sales, I can just click Kelly Williams and it filters the information. 02:49.000 --> 02:59.000 Anna filters the information. Chuck pretty cool. So that's a one click option. That's really easy to use. 02:59.000 --> 03:07.000 If I go to the other dashboard, I have to have something like this with a filter. 03:07.000 --> 03:15.000 When you make changes to any of the elements here, it doesn't affect the original sheet. 03:15.000 --> 03:20.000 So you can choose to include or exclude items. 03:20.000 --> 03:28.000 I'm going to go over here. I don't want to see the title. If I take out the title here, it doesn't take out the title in the original sheet. 03:28.000 --> 03:32.000 I don't like the text table title here. I'm going to go over here and take that out. 03:32.000 --> 03:44.000 And so when I do that, it takes that out of here. But if I go back to the original text table, it still keeps it there. 03:44.000 --> 03:48.000 I'm going to go to dashboard. 03:48.000 --> 03:52.000 Let me see if I have a filter option here. 03:52.000 --> 04:03.000 I could use it as filter. I'll use it as filter. I'll click this. 04:03.000 --> 04:07.000 Yeah, no, it's not working. So I have to have a special type of object. 04:07.000 --> 04:17.000 So I won't be able to do that here. But if you have a regular filter, you can have the filter apply across multiple objects in this worksheet. 04:17.000 --> 04:23.000 You want to be careful because you don't want to use the option where it filters all the worksheets. 04:23.000 --> 04:30.000 There is an option that's going to allow you to choose works selected worksheets on this dashboard. 04:30.000 --> 04:35.000 And that's the option you want to choose. 04:35.000 --> 04:43.000 So I'm going to go over here, click on this object, and I'm just going to. 04:43.000 --> 04:47.000 Yeah, so I don't have anything here. 04:47.000 --> 04:52.000 I want to publish this to my Tableau dashboard. 04:52.000 --> 05:00.000 So all you have to do is now you'll finally click the save button, and this will upload it to the Tableau dashboard. 05:00.000 --> 05:05.000 You might have to play around with it. If I want to do a preview, I'll click here. 05:05.000 --> 05:12.000 And then I can preview clicking and filtering the information and seeing how it looks. 05:12.000 --> 05:15.000 And it is working. 05:15.000 --> 05:20.000 I want to go to page two, I'll click page two, and I go to page two. 05:20.000 --> 05:27.000 I can go over here and I can turn on. 05:27.000 --> 05:31.000 My looping display. 05:31.000 --> 05:40.000 For years. 05:40.000 --> 05:44.000 You can also control the speed, whether it's slower fast. 05:44.000 --> 05:48.000 I'll click page one and it goes back here. 05:48.000 --> 05:54.000 I'm going to press escape and now I'm going to save it to my public Tableau. 05:54.000 --> 05:57.000 I'm just going to choose save to Tableau public. 05:57.000 --> 06:00.000 And it's just going to go through the process of uploading it. 06:00.000 --> 06:02.000 I have to sign in. 06:02.000 --> 06:07.000 So. 06:07.000 --> 06:08.000 It's doing its work. 06:08.000 --> 06:10.000 It's publishing all the pages. 06:10.000 --> 06:17.000 And the thing that happens automatically is after it does this, it takes you directly to Tableau public. 06:17.000 --> 06:24.000 And now I have my visualization just like any other visualization published by me. 06:24.000 --> 06:28.000 I can send people a link to it and they can interact with it. 06:28.000 --> 06:32.000 The filters work just like they did locally on my computer. 06:32.000 --> 06:39.000 People can do this and they can click page two and go to my other visualization here. 06:39.000 --> 06:43.000 And then they can click on the arrows. 06:43.000 --> 06:50.000 And then they can see the information across multiple years. 06:50.000 --> 06:59.000 There is a way if you have a certain type of filter to filter both the text table and the filter across multiple years. 06:59.000 --> 07:01.000 But I didn't include that visualization. 07:01.000 --> 07:06.000 I can go back to page one. 07:06.000 --> 07:09.000 When you go to your settings. 07:09.000 --> 07:11.000 I have to sign in. 07:11.000 --> 07:15.000 Let me refresh because I think. 07:15.000 --> 07:18.000 I have to sign in twice. 07:18.000 --> 07:23.000 It's showing me how it looks to other people, but then I have to sign in. 07:23.000 --> 07:25.000 Okay, so now I've signed in. 07:25.000 --> 07:27.000 And now I have the gear icon. 07:27.000 --> 07:30.000 I don't want people to see my visualization. 07:30.000 --> 07:31.000 Go Viz on profile. 07:31.000 --> 07:34.000 I can turn this off. 07:34.000 --> 07:37.000 Allow access. 07:38.000 --> 07:41.000 Let others download or make a copy of this visualization. 07:41.000 --> 07:44.000 I can turn it off by default. 07:44.000 --> 07:46.000 It's turned on. 07:46.000 --> 07:48.000 Show sheets. 07:48.000 --> 07:50.000 If I choose to show sheets. 07:50.000 --> 07:53.000 I can see the sheets that made up these visualizations. 07:53.000 --> 07:56.000 There they are right here. 07:56.000 --> 08:01.000 And I can click on any of these sheets and see everything. 08:01.000 --> 08:04.000 But I just wanted to show the visualizations. 08:04.000 --> 08:10.000 So I can hide that and then just show the dashboards. 08:10.000 --> 08:14.000 That display the visualizations. 08:14.000 --> 08:16.000 And then this would be the completed lesson. 08:16.000 --> 08:17.000 I'm sharing information. 08:17.000 --> 08:18.000 I created something. 08:18.000 --> 08:20.000 People can look at it. 08:20.000 --> 08:25.000 I can add my own images and links and so on.