1 00:00:00,480 --> 00:00:05,300 And this video, we will learn about the secrets of barometer's and poverty. 2 00:00:06,420 --> 00:00:09,610 So here we have one example, David. 3 00:00:10,020 --> 00:00:10,830 Let me show you. 4 00:00:11,850 --> 00:00:16,460 The underlying values, so here we had product stable, right? 5 00:00:17,010 --> 00:00:29,640 So we have these type of columns in it and we are interested in the column like a category and the list 6 00:00:29,640 --> 00:00:30,120 price. 7 00:00:30,450 --> 00:00:32,180 It contains 297 rules. 8 00:00:32,190 --> 00:00:39,570 For example, we have like millions of barrels in the table and we don't want to load all the data at 9 00:00:39,570 --> 00:00:39,970 once. 10 00:00:40,830 --> 00:00:50,430 So, for example, depending on the user, we can select the data based on the categories like Tetris 11 00:00:50,430 --> 00:00:52,260 by example, loading components. 12 00:00:53,370 --> 00:01:01,710 And we need to pass these parameters so that the data only for the selected category so can create. 13 00:01:01,710 --> 00:01:06,720 And how many how many types of parameters are available in poverty. 14 00:01:07,050 --> 00:01:09,510 We will go through one by one in detail. 15 00:01:10,110 --> 00:01:15,390 So let's go to the power ed transform data. 16 00:01:17,590 --> 00:01:26,620 And here you can see this is a managed perimeter, so you can click here either for the new perimeter 17 00:01:26,620 --> 00:01:29,710 because we don't have any perimeter at the moment. 18 00:01:30,970 --> 00:01:35,380 Like if I click manage perimeter, we will get nothing and you can click new. 19 00:01:35,860 --> 00:01:39,910 Otherwise you can also click a new perimeter here. 20 00:01:41,260 --> 00:01:43,570 So the first perimeter is here, you can see. 21 00:01:44,540 --> 00:01:51,740 We have suggested we had these three types of parameters, any value list value articulates for the 22 00:01:51,740 --> 00:02:00,980 name of the perimeter will be on the score any value as you can write, any description. 23 00:02:04,100 --> 00:02:15,170 I like any value type is our type of parametrized text, because we need to provide categories and what 24 00:02:15,170 --> 00:02:16,010 is the current value? 25 00:02:16,820 --> 00:02:19,970 The current value is possible buycks. 26 00:02:23,380 --> 00:02:24,880 And we just need to click, OK? 27 00:02:26,350 --> 00:02:33,940 So here here you can see we are getting one barometer part on the value the bike spending are wrong, 28 00:02:35,470 --> 00:02:38,880 so we need to click again to the perimeter around the perimeter. 29 00:02:40,030 --> 00:02:54,040 And here we have to ride bikes like, OK, and now the perimeter is there and now we need to associate 30 00:02:55,000 --> 00:02:58,250 this perimeter with the products table. 31 00:02:58,900 --> 00:03:01,780 So let's go to the corner where we need to associate. 32 00:03:02,500 --> 00:03:04,690 So click here and 33 00:03:07,510 --> 00:03:07,840 here. 34 00:03:07,840 --> 00:03:10,780 You have to click text filters equal to. 35 00:03:13,770 --> 00:03:21,020 And here we have to choose the type parameter and what is the name of the perimeter A and the score, 36 00:03:21,030 --> 00:03:21,660 any value. 37 00:03:22,200 --> 00:03:22,520 OK. 38 00:03:26,340 --> 00:03:33,810 And here you can see we are getting all the values that belong to bikes and if your clothes and apply. 39 00:03:41,530 --> 00:03:48,310 So here you will see we are getting all the data that belong to categories and let's again go to the 40 00:03:48,310 --> 00:03:53,980 poverty Ed. If you want to change this parameter to assessors 41 00:03:57,700 --> 00:04:01,150 and then we need to just close and apply. 42 00:04:04,550 --> 00:04:11,540 And here you can see we are getting all the data that belonged to assess risk by using this kind of 43 00:04:11,670 --> 00:04:16,740 parameter, any value you can type, any value by your own. 44 00:04:16,940 --> 00:04:18,850 You don't have any option to choose here. 45 00:04:19,400 --> 00:04:21,800 So let's try to create one more parameter. 46 00:04:24,300 --> 00:04:26,760 Manage perimeter, new perimeter. 47 00:04:26,970 --> 00:04:30,660 So here we have the right like and the underscore. 48 00:04:31,290 --> 00:04:38,580 What is the name of the next is a list value so far on the list 49 00:04:41,310 --> 00:04:46,800 and choose any value from the list. 50 00:04:47,400 --> 00:04:50,970 This is the description and here it is again. 51 00:04:50,970 --> 00:04:55,550 Text this Destra value is his list of values. 52 00:04:56,550 --> 00:05:04,500 And here we have to write the list manually so we can create this kind of parameter based on the static 53 00:05:04,500 --> 00:05:06,180 values, like a few values. 54 00:05:06,930 --> 00:05:09,200 So here is the first value is buycks. 55 00:05:13,340 --> 00:05:13,970 Claudine. 56 00:05:21,010 --> 00:05:25,120 These are the three values, and here you can choose Asmal bikes. 57 00:05:26,160 --> 00:05:31,530 And the current value will be, again, fuzzball bikes click, OK? 58 00:05:33,330 --> 00:05:42,230 And if you look here in the product, this is category and here we have two bikes. 59 00:05:42,300 --> 00:05:44,370 So why bikes is not fair? 60 00:05:44,370 --> 00:05:48,320 Because this value is not being associated with this category. 61 00:05:48,960 --> 00:05:53,450 So we have to click here and clear filter. 62 00:05:54,710 --> 00:05:59,120 And here we have to again click on the text filter equal to. 63 00:06:01,050 --> 00:06:11,310 We have to choose here barometer and the battle has taken parameters, the list, the the newly created 64 00:06:11,320 --> 00:06:12,000 better click. 65 00:06:12,100 --> 00:06:15,000 OK, so here you can see this is a buycks. 66 00:06:15,390 --> 00:06:21,560 If you click again to the part list like here, you can choose any value that you have written in the 67 00:06:21,570 --> 00:06:23,190 part in the score list parameter. 68 00:06:23,220 --> 00:06:27,450 So now let's go to the third type of parameter transformed into. 69 00:06:29,550 --> 00:06:33,750 And we need to click a new perimeter and here you can see. 70 00:06:35,480 --> 00:06:42,360 The third parameter is the Kutty, so this is the third parameter is a dynamic parameter. 71 00:06:42,380 --> 00:06:51,700 So if you go to the product category, so here you can see we are getting these parameters in the table. 72 00:06:52,190 --> 00:07:00,620 If you have a big table that contains like 20, 25 ARIAD parameters are being changed are pretty frequently, 73 00:07:01,160 --> 00:07:06,890 then you have to create dynamic parameter that is based on some table. 74 00:07:08,180 --> 00:07:16,970 And how to create that kind of barometer for this, you need to create a list click we can make a copy 75 00:07:16,970 --> 00:07:17,600 of this table. 76 00:07:18,910 --> 00:07:19,640 Duplicate. 77 00:07:20,290 --> 00:07:22,720 And here is the list. 78 00:07:23,140 --> 00:07:26,710 This is the name of the table, and then we need to click. 79 00:07:31,560 --> 00:07:36,960 And you know how to create lists in the Skilbeck, and we need to write the name of the column English. 80 00:07:47,680 --> 00:07:49,430 That's it. 81 00:07:50,320 --> 00:07:52,280 So here we have a new list. 82 00:07:52,310 --> 00:08:01,920 No, we need to create the third perimeter, new perimeter, and this is the bar underscore gearing. 83 00:08:02,200 --> 00:08:03,460 This is the name of the perimeter. 84 00:08:04,030 --> 00:08:08,550 As you can write any description here, the type is, again, text. 85 00:08:09,250 --> 00:08:10,750 And here we have to call security. 86 00:08:12,040 --> 00:08:18,530 So here we have to choose a category list, this one, and what is the current value? 87 00:08:19,330 --> 00:08:22,420 This is for underbite click, OK? 88 00:08:24,610 --> 00:08:30,160 And now we need to associate this parameter with the products table. 89 00:08:31,690 --> 00:08:33,730 Well, here in the category. 90 00:08:34,680 --> 00:08:41,160 We need to create a filter and here we have to again to filter equal to. 91 00:08:43,750 --> 00:08:49,360 Aerial pictures of the perimeter and the third volume, which is part of this mercury, that's it. 92 00:08:49,610 --> 00:08:55,690 No, we don't need the other parameters, like partners of you can delete this one. 93 00:08:56,990 --> 00:08:59,000 And for clothing. 94 00:09:00,670 --> 00:09:07,540 And the parameter list with this one, so we have only one parameter closed and applied. 95 00:09:11,130 --> 00:09:14,650 And if I click transform later edit parameter. 96 00:09:15,660 --> 00:09:21,020 So here you can see I'm getting this parameter list here. 97 00:09:21,450 --> 00:09:27,940 If I click component's the data from the components category will be loaded. 98 00:09:28,140 --> 00:09:28,970 So here you can see. 99 00:09:29,070 --> 00:09:30,530 So it's a component, right. 100 00:09:31,140 --> 00:09:36,540 And if we click added parameter, then again the popup will come. 101 00:09:36,930 --> 00:09:43,020 And here, Riganti here you can choose like laddy recook and apply changes. 102 00:09:46,300 --> 00:09:48,220 So here you can see glutting, right? 103 00:09:49,770 --> 00:09:54,990 And we need to use one more parameter here. 104 00:09:56,600 --> 00:09:58,350 Let's go to the transport data. 105 00:09:58,370 --> 00:10:00,830 So here I need to create one more perimeter. 106 00:10:02,100 --> 00:10:07,650 A new perimeter, and the name is far undisclosed price. 107 00:10:12,690 --> 00:10:20,570 The value is decimal number, and here you can choose any value and it's like 12 click, OK. 108 00:10:22,710 --> 00:10:28,500 And now we need to apply this parameter to the list price. 109 00:10:30,300 --> 00:10:31,650 Here we have one column. 110 00:10:33,550 --> 00:10:34,390 The list price. 111 00:10:38,130 --> 00:10:43,910 And greater than to choose parameter price. 112 00:10:45,090 --> 00:10:45,420 OK. 113 00:10:46,200 --> 00:10:54,000 OK, so as you can see, we are getting all the list price, which is greater than twelth this one and 114 00:10:54,600 --> 00:10:56,340 no closer and apply. 115 00:10:59,010 --> 00:10:59,520 And. 116 00:11:02,060 --> 00:11:03,230 Here if I click. 117 00:11:04,410 --> 00:11:12,270 Edit perimeter, so here you're going to see the clothing like accessories and gender bias, I can right 118 00:11:12,270 --> 00:11:13,920 here like 50 greater than 50. 119 00:11:15,510 --> 00:11:17,010 So you will see here. 120 00:11:20,440 --> 00:11:21,640 Life changes. 121 00:11:23,860 --> 00:11:32,500 So assesses and then 50, right, so you can choose multiple parameters in it, and let's let me show 122 00:11:32,500 --> 00:11:33,780 you one last part. 123 00:11:34,510 --> 00:11:39,700 So we need to save this file as a. 124 00:11:40,800 --> 00:11:42,270 Powered by template. 125 00:11:44,180 --> 00:11:46,430 And the name is We Can Right Here 126 00:11:49,520 --> 00:11:50,410 Barometer's 127 00:11:54,380 --> 00:12:04,100 is when you will send this file to anybody, he cannot see all the data at once if it's he needs to 128 00:12:04,340 --> 00:12:04,880 choose. 129 00:12:06,220 --> 00:12:10,060 The parameters, and then he will see the data accordingly. 130 00:12:10,270 --> 00:12:12,610 So Nabarlek. 131 00:12:16,550 --> 00:12:19,010 And here you will see these two, PennyMac. 132 00:12:19,940 --> 00:12:23,510 This is a dynamic perimeter body's capacity to heal. 133 00:12:23,540 --> 00:12:30,810 You can choose like clothing and you can choose the place, like if I said greater than 20. 134 00:12:30,830 --> 00:12:38,020 So the data that fulfill these criteria that will be loaded, so is clothing and despises. 135 00:12:38,780 --> 00:12:43,540 Well, so this is all about input parameters in poverty.