WEBVTT 00:00.000 --> 00:05.000 I'm going to assign this to a calculated field. 00:05.000 --> 00:09.000 So I need to create a calculated field. 00:09.000 --> 00:15.000 This calculated field is going to be called state focus. 00:15.000 --> 00:22.000 So I'm going to go to state selector. 00:22.000 --> 00:25.000 I'm going to choose create. 00:25.000 --> 00:28.000 And I'm going to choose calculated field. 00:29.000 --> 00:33.000 So I can create a calculated field directly from the state selector. 00:33.000 --> 00:36.000 I could also create a calculated field up here. 00:36.000 --> 00:39.000 And just click create calculated field. 00:39.000 --> 00:41.000 But if I do it from the state selector, 00:41.000 --> 00:47.000 it's automatically going to include the state selector in the calculated field. 00:47.000 --> 00:49.000 And there it is. 00:49.000 --> 00:53.000 I'm going to call this state focus. 00:53.000 --> 00:56.000 I know we have all these names. 00:56.000 --> 01:10.000 And I'm going to say the state selector is equal to state. 01:10.000 --> 01:13.000 And that's what we're going to do. 01:13.000 --> 01:16.000 So. 01:16.000 --> 01:24.000 I think that's all I need to do. 01:24.000 --> 01:31.000 I'll click OK. 01:31.000 --> 01:35.000 Now I call this state selector in the instructions. 01:35.000 --> 01:38.000 It was state parameter, but same difference. 01:38.000 --> 01:41.000 I'm saying it has to be equal to the state. 01:41.000 --> 01:43.000 I'm going to click OK. 01:43.000 --> 01:45.000 And now it's over here. 01:45.000 --> 01:48.000 There's like a true false thing here. 01:48.000 --> 01:50.000 Now for this to work, 01:50.000 --> 01:53.000 I need to actually move it over into the filter. 01:53.000 --> 01:59.000 Because what's the point of doing that without having it filter the states. 01:59.000 --> 02:03.000 So I'm going to drag this over and bring it into the filters. 02:03.000 --> 02:07.000 And I'm going to say when it's true. 02:07.000 --> 02:13.000 When the state selector is equal to the state filter the state. 02:13.000 --> 02:20.000 So I'm going to drag state focus over into filters. 02:20.000 --> 02:24.000 This comes up and it's like a true fault statement. 02:24.000 --> 02:27.000 I'm going to click here on true. 02:27.000 --> 02:32.000 And I'm going to click OK. 02:32.000 --> 02:35.000 And it's already starting to work. 02:35.000 --> 02:41.000 So now it's in New Mexico. 02:41.000 --> 02:43.000 I want to get this to show. 02:43.000 --> 02:48.000 So I need to bring up the controls where I can change this right now. 02:48.000 --> 02:51.000 Now I can't change anything. 02:51.000 --> 02:54.000 So I'm going to go to the state selector. 02:54.000 --> 03:01.000 I'll click the drop down here and I want to show the parameter. 03:01.000 --> 03:04.000 For some reason, I thought it was going to default to New York. 03:04.000 --> 03:06.000 It didn't seem to do that. 03:06.000 --> 03:10.000 But let me now choose New York. 03:10.000 --> 03:12.000 And now I see New York. 03:12.000 --> 03:15.000 I'll click here Minnesota. 03:15.000 --> 03:21.000 I see Minnesota and their sales. 03:21.000 --> 03:24.000 So now I've created a custom control. 03:24.000 --> 03:27.000 If I put this into my dashboard. 03:27.000 --> 03:33.000 When someone sees this as a dashboard, they could use this to navigate to any individual state. 03:33.000 --> 03:36.000 And see the sales for each state. 03:45.000 --> 03:53.000 OK, I'll press Escape. 03:53.000 --> 04:02.000 And I'm going to call this state selector. 04:02.000 --> 04:09.000 This is ready for me to add to my dashboard whenever I'm ready. 04:09.000 --> 04:15.000 One of the reasons this might not work is if you fuss around with the zoom controls. 04:15.000 --> 04:21.000 If I let's say zoom out a little bit. 04:21.000 --> 04:26.000 I've sort of like canceled out my ability to use the state selector. 04:26.000 --> 04:28.000 This has happened to me before in class. 04:28.000 --> 04:34.000 And then sometimes it could take you a while before you figure out what's going on and why it's not working. 04:34.000 --> 04:39.000 If I click the drop down here and choose another state. 04:39.000 --> 04:45.000 Hey Garfield, I created it exactly like you said, but it's not moving. 04:45.000 --> 04:47.000 This has happened to me in class. 04:47.000 --> 04:51.000 It's been embarrassing when I couldn't figure this out. 04:51.000 --> 04:54.000 And then you figure stuff out and then you don't do it again. 04:54.000 --> 04:59.000 Because you remember when it happened and say I'm never going to do that again. 04:59.000 --> 05:03.000 And so I need to cancel out of this zoom level. 05:03.000 --> 05:06.000 And then just reset the map. 05:06.000 --> 05:19.000 Now if I go back here and then use the state selector, it now works. 05:19.000 --> 05:23.000 So that was one of the issues where I had trouble with this. 05:23.000 --> 05:29.000 Also, if you have other filters in that filter section, that can also affect. 05:29.000 --> 05:32.000 Because the filters will be fighting with each other. 05:32.000 --> 05:41.000 There's certain no-nose when it comes to using multiple filters. 05:41.000 --> 05:47.000 Let me see what is different than using a filter. 05:47.000 --> 05:58.000 So, at least for this, you're jumping specifically to the area. 05:58.000 --> 06:00.000 And let's see. 06:00.000 --> 06:02.000 Let's actually take a look at that. 06:02.000 --> 06:05.000 What's different than using a filter? 06:05.000 --> 06:09.000 I think the behavior is going to be different. 06:09.000 --> 06:13.000 Let me create a duplicate of this. 06:13.000 --> 06:21.000 I sort of had the same question myself, but let me take this out. 06:21.000 --> 06:27.000 And so I'm going to take state, I'm going to bring it in here. 06:27.000 --> 06:35.000 Let's use, do I want to use all? 06:35.000 --> 06:37.000 Or do I want to use one? 06:37.000 --> 06:41.000 Yeah, I'll use all. 06:41.000 --> 06:43.000 Okay, so there it is. 06:43.000 --> 06:47.000 I'm going to go over here and I'm going to show a filter. 06:47.000 --> 06:52.000 Oh no, I don't like this. 06:52.000 --> 06:55.000 No, Garfield, that's not how you're supposed to do it. 06:55.000 --> 07:02.000 What you're supposed to do is you're supposed to change this to a single value list. 07:02.000 --> 07:07.000 Okay, so here we go. 07:07.000 --> 07:12.000 This is sort of working. Okay, let me click the drop down. 07:12.000 --> 07:16.000 I don't like seeing all 50 states here. 07:16.000 --> 07:21.000 So I'm going to go over here and choose a single value drop down. 07:21.000 --> 07:24.000 I'll go here. 07:24.000 --> 07:33.000 This seems to be working fine. 07:33.000 --> 07:39.000 There is, why does a state selector doing here? 07:39.000 --> 07:45.000 Let me take it out. 07:45.000 --> 07:50.000 I want to make sure that the state selector isn't helping the filter and do this. 07:50.000 --> 07:58.000 So I want to take this out. 07:58.000 --> 08:02.000 Edit the parameter. 08:02.000 --> 08:08.000 All right, so I'm going to close. I'm going to take this out. 08:08.000 --> 08:15.000 I'd card. 08:15.000 --> 08:17.000 I'll go into the presentation. 08:17.000 --> 08:29.000 This is not bad in terms of having this do what the state selector does. 08:29.000 --> 08:39.000 But let me go to another sheet. 08:39.000 --> 08:44.000 Let's go to region. 08:44.000 --> 08:58.000 Okay, let me go over here and then show the parameter. 08:58.000 --> 09:03.000 Okay, so this is. 09:03.000 --> 09:09.000 Oh, yeah, so I show the parameter and then I'm going to go over to state focus. 09:09.000 --> 09:18.000 I'm just going to drag it here and then I'll choose true. 09:18.000 --> 09:25.000 It might be a little negligible, but I think one of the advantages is that. 09:25.000 --> 09:31.000 This is available on multiple sheets, at least the state selector. 09:31.000 --> 09:38.000 The filter you'll have to create from scratch on every sheet. 09:38.000 --> 09:43.000 So if you're creating a parameter, you have it available on all the sheets. 09:43.000 --> 09:46.000 State focus, as you can see, I didn't create it here. 09:46.000 --> 09:51.000 It was already available. All I had to do is drag it in here and select true. 09:51.000 --> 09:56.000 And then just display the state selector. 09:56.000 --> 10:01.000 So it's global versus local. 10:01.000 --> 10:07.000 I would say at least one of the advantages. 10:07.000 --> 10:12.000 And you may have different reasons why you would use one over the other. 10:12.000 --> 10:18.000 But that is definitely a reason to use. 10:18.000 --> 10:20.000 Use a parameter. 10:20.000 --> 10:29.000 All right, so I'm going to hide this. I don't want to use this here and I'm going to take this away. 10:29.000 --> 10:34.000 Notice that now the parameter works as intended, but there is another problem. 10:34.000 --> 10:42.000 There is another problem with this and the problem if I go back to state selector. 10:42.000 --> 10:47.000 I'm going to delete this sheet. 10:47.000 --> 10:52.000 I don't have a way to return back to all the states. 10:52.000 --> 10:56.000 I'm stuck. I can only go one state at a time. 10:56.000 --> 10:59.000 I'm going to go back and select all the states. 10:59.000 --> 11:02.000 Would I be able to do that with a filter? 11:02.000 --> 11:06.000 Yes, I think I would be able to. They do have the option for all. 11:06.000 --> 11:13.000 But this doesn't. I want to build that in and I want to be able to access it on all the worksheets. 11:13.000 --> 11:21.000 So we're going to have to edit the state selector. 11:21.000 --> 11:23.000 Or actually the state focus. 11:23.000 --> 11:26.000 So locate the state parameter. 11:26.000 --> 11:28.000 Click on it in its menu. 11:28.000 --> 11:31.000 And before we had state parameter. 11:31.000 --> 11:34.000 Although for us, it states selector equal state. 11:34.000 --> 11:39.000 We're going to have to do or equal all. 11:39.000 --> 11:44.000 So we have to go in and edit the state selector. 11:44.000 --> 11:51.000 I'm going to go down here to the bottom and choose edit. 11:51.000 --> 11:55.000 I don't have an all as an option. 11:55.000 --> 11:59.000 So I'm going to scroll down here. 11:59.000 --> 12:01.000 And I'm going to add one. 12:01.000 --> 12:07.000 I'm going to say all. 12:07.000 --> 12:11.000 I mean, make sure I get the spelling right. 12:11.000 --> 12:17.000 The value is all and I'm going to display it as all states. 12:17.000 --> 12:22.000 So all and then the display is all states. 12:22.000 --> 12:25.000 The display can be whatever I want. 12:25.000 --> 12:31.000 But the value has to be all. 12:31.000 --> 12:35.000 I'm going to take this and I want to move it all the way to the top. 12:35.000 --> 12:37.000 Because I want it to be at the top. 12:37.000 --> 12:42.000 I want it to be the first option from the drop down. 12:42.000 --> 12:46.000 Okay, so I'm going to do that and I'm going to click OK. 12:46.000 --> 12:53.000 Now I'm going to go and customize my state focus. 12:53.000 --> 12:56.000 Which is available on every single sheet. 12:56.000 --> 12:59.000 I only have to change it one place. 12:59.000 --> 13:03.000 I'm going to choose edit. 13:03.000 --> 13:08.000 And I'm going to say or. 13:08.000 --> 13:13.000 State selector equals all. 13:13.000 --> 13:19.000 I'm going to copy this part here. 13:19.000 --> 13:22.000 Paste. 13:22.000 --> 13:26.000 And then I'll put in double quotes a. 13:26.000 --> 13:30.000 Hell out. 13:30.000 --> 13:32.000 Okay, I'll click OK. 13:32.000 --> 13:37.000 This is now already in the sheet and it's working. 13:37.000 --> 13:40.000 I'm going to click the drop down here and I scroll to the top. 13:40.000 --> 13:42.000 I see all states. 13:42.000 --> 13:44.000 I'm going to select all states. 13:44.000 --> 13:49.000 And now it returns to all of the states. 13:49.000 --> 13:52.000 So now this is a fully customizable control. 13:52.000 --> 13:59.000 I can go to any individual state and I can go to all states. 13:59.000 --> 14:08.000 I just needed to go to the state selector and all as one of the options. 14:08.000 --> 14:12.000 How does the map know all is all states. 14:12.000 --> 14:13.000 I see it works. 14:13.000 --> 14:16.000 But how does it know? 14:16.000 --> 14:21.000 Yeah, it's a syntax thing. 14:21.000 --> 14:28.000 So all is a keyword that means all the values in the list. 14:28.000 --> 14:38.000 And let's see if there's anything else to go over here. 14:38.000 --> 14:40.000 No, that's basically it. 14:40.000 --> 14:44.000 This is one example of creating a custom control. 14:44.000 --> 14:47.000 It might not be the one that you're going to use for your project. 14:47.000 --> 14:50.000 But it shows you that something like this is possible. 14:50.000 --> 14:54.000 There may be something else that you want to choose to filter by. 14:54.000 --> 14:56.000 And maybe it's not state. 14:56.000 --> 15:00.000 So you can use a custom control for that. 15:00.000 --> 15:02.000 And so it's custom to you. 15:02.000 --> 15:08.000 It's like a user defined function. 15:08.000 --> 15:11.000 Yeah, but I wondered the I wondered the same thing when I saw this. 15:11.000 --> 15:15.000 I was like, how does all mean all the states. 15:15.000 --> 15:20.000 And it's just a syntax thing in tablo. 15:20.000 --> 15:25.000 So that's an example of creating a parameter and then creating a state selector. 15:25.000 --> 15:31.000 And so that's an example of creating a parameter. 15:31.000 --> 15:37.000 And so that's an example of creating a parameter. 15:37.000 --> 15:41.000 And so that's an example of creating a parameter. 15:41.000 --> 15:45.000 And so that's an example of creating a parameter. 15:45.000 --> 15:49.000 And so that's an example of creating a parameter. 15:49.000 --> 15:53.000 And so that's an example of creating a parameter.