WEBVTT 00:00.120 --> 00:03.160 OK, so let's look at the table visualization now. 00:03.180 --> 00:08.790 Create a dashboard, add an empty panel up here time series select table. 00:08.830 --> 00:11.930 OK, so it's a table for the data source. 00:11.940 --> 00:14.070 Let's change that to being. 00:15.310 --> 00:16.690 Random walk table. 00:17.140 --> 00:22.630 OK, so that gives us a few extra columns that we can look at can bring that across. 00:23.780 --> 00:24.850 This is still random. 00:25.270 --> 00:26.590 Each time you refresh it. 00:26.740 --> 00:32.710 OK, so may just resizing the column there has actually created some overrides for us, so you can either 00:32.710 --> 00:37.060 leave them or delete them if you wanted to, and it would go back to the way it was. 00:38.530 --> 00:41.080 Individual column weights will comes through with an override. 00:41.200 --> 00:43.270 Anyway, we'll look at overrides more in a moment. 00:43.660 --> 00:48.730 So panel options, of course, we can change the title my table and I can set a description. 00:48.880 --> 00:50.470 That's the title we wanted. 00:50.600 --> 00:52.180 It's a transparent background. 00:52.780 --> 00:55.930 OK, the table show header goes no hitter. 00:55.930 --> 00:58.180 Now we'll put that back on because it makes more sense. 00:58.240 --> 01:04.470 Column width The minimum column width 150 said that to be 100, it makes them all a little bit less 01:04.480 --> 01:04.870 there. 01:04.870 --> 01:11.320 There is no override added there because it's affecting the table as a whole column with auto, we can 01:11.320 --> 01:14.470 align left, center or right. 01:14.590 --> 01:15.880 I'll keep that auto. 01:17.350 --> 01:18.370 Column filters. 01:18.610 --> 01:27.070 OK, so that's this at the top that allows you to order by a value ascending or descending or even select 01:27.070 --> 01:29.230 a particular bunch of values. 01:29.260 --> 01:29.770 OK? 01:29.830 --> 01:33.160 That I'm going to clear the filter, OK, I'm going to narrow for now. 01:33.760 --> 01:37.690 Come back to that OK, table standard options unit. 01:37.960 --> 01:40.120 We can say anything we like. 01:40.300 --> 01:41.100 OK, minutes. 01:41.110 --> 01:43.750 They're all the numeric values are arc minutes. 01:44.380 --> 01:48.430 I'm going to leave that as a non decimal color scheme from thresholds. 01:48.590 --> 01:49.510 Look at that in the moment. 01:50.800 --> 01:56.320 Thresholds, we can use those threshold collars to change the style of the table, so going back to 01:56.320 --> 02:00.640 table cell display mode, auto color text. 02:00.760 --> 02:07.930 OK, so that text is colored from the threshold color, background gradient or solid gradient gauge 02:08.530 --> 02:16.180 LCD gauge, a basic gauge or adjacent view, just a data as it appears when it's entered into the system. 02:16.180 --> 02:19.570 As Jason, when to put it on colored background gradient. 02:19.660 --> 02:23.950 OK, so now we can modify the thresholds, although threshold. 02:24.250 --> 02:25.540 OK, so OK. 02:25.540 --> 02:30.270 So the date behind the scene is actually a long number, which is like an integer, but very large. 02:30.280 --> 02:35.260 So when you convert that date to a low number, it's actually in the millions and it's way above eighty 02:35.260 --> 02:35.560 three. 02:35.570 --> 02:37.570 So that's what's showing up as yellow there. 02:37.750 --> 02:40.270 But anyway, we'll come on to managing individual columns anyway. 02:40.270 --> 02:47.020 So if I want to see different colors amongst the I, the mean and the Max, for example, I can choose 02:47.170 --> 02:48.070 everything. 02:48.100 --> 02:50.050 Eighty four and above will be red. 02:50.140 --> 02:57.730 So everything under eighty four is green or green could change at 83, for example, and for yellow, 02:57.820 --> 03:00.810 everything 84 and above is yellow. 03:00.820 --> 03:04.840 If I have a number below 83, that will reorder there. 03:04.850 --> 03:07.460 So if I said eighty two, it's put it down there. 03:07.480 --> 03:12.070 So 83 82, okay, so we go one yellow so they can play around with that. 03:12.970 --> 03:16.990 Take so value mappings, for example, like we've seen earlier. 03:17.140 --> 03:25.630 We can add value mapping for anything such as a range between eighty three point one and eighty three 03:25.630 --> 03:26.500 point three. 03:26.510 --> 03:30.670 It is broken and we can set a column date. 03:30.760 --> 03:31.990 Okay, so we've got one broken. 03:31.990 --> 03:33.040 They're broken. 03:33.040 --> 03:34.340 They're just an example. 03:34.360 --> 03:36.670 I'm going to delete that update. 03:37.030 --> 03:37.410 OK. 03:37.630 --> 03:38.170 And. 03:39.310 --> 03:40.150 Dot links. 03:40.300 --> 03:45.560 We can add a link, for example, or info, and we can link to a web page. 03:45.580 --> 03:52.330 For example, my grandfather documentation page, if I want, I can add a query string so something 03:52.390 --> 03:55.090 equals I can use any of these options. 03:55.300 --> 03:55.960 Numeric. 03:56.500 --> 03:57.850 Open a new tap save. 03:58.000 --> 03:59.440 So now these numbers are links. 03:59.540 --> 04:02.530 If I click on any of those, say 86 there. 04:02.590 --> 04:06.250 It opens a new browser and the query string has something else. 04:06.370 --> 04:08.740 That's the actual number behind the. 04:08.740 --> 04:15.550 So even though it says 86 there, that's been rounded automatically to a decimal place using the decimals 04:15.550 --> 04:15.820 there. 04:15.850 --> 04:18.270 So I could say I'm going to have 10 decimal places. 04:18.310 --> 04:23.740 For example, when you see eighty five point nine six, eighty five point nine, six, etc., all letters 04:23.740 --> 04:24.070 all do. 04:25.180 --> 04:31.750 OK, so let's apply that for now, and that's a table on our dashboard, although it does look a little 04:31.750 --> 04:37.750 bit messy, we can improve on that and we can make these effects apply to individual columns only. 04:37.780 --> 04:39.070 So let's go back into that. 04:39.070 --> 04:39.910 I'm pressing a. 04:40.480 --> 04:49.270 OK, so let's put it back to the way it was before color background auto and I'll remove the data link. 04:50.860 --> 04:57.000 I'll keep the thresholds for now, let's add an individual override, say, for Column I. 04:57.210 --> 05:01.980 OK, so fields with name choose I add an override property. 05:03.550 --> 05:06.980 So display mode being color background. 05:07.000 --> 05:09.790 OK, so the column is now highlighted red. 05:10.510 --> 05:12.400 I'm going to do the same thing for the info column. 05:12.640 --> 05:21.130 OK, so you override to add a filter override fields with name, choose info override property. 05:21.280 --> 05:22.510 So display mode. 05:23.450 --> 05:25.090 Color, background gradient. 05:25.250 --> 05:25.700 Excellent. 05:25.730 --> 05:30.740 Now, actually, I'll make this one an LCD, so let's go back to override one. 05:31.310 --> 05:32.450 You know, he's an LCD. 05:32.540 --> 05:39.050 OK, so that looks quite interesting now with the info I can show down being read, for example, so 05:39.050 --> 05:43.970 I'll get back to override two and I'll add an override property being. 05:45.720 --> 05:46.860 A value mapping. 05:47.280 --> 05:53.130 Let's look at the value mappings, the condition value down. 05:53.850 --> 05:57.450 Let's set the color as red update. 05:57.630 --> 06:00.100 OK, so when it sits down, it's now red. 06:00.120 --> 06:01.780 Otherwise, its default green. 06:02.220 --> 06:02.820 Excellent. 06:02.850 --> 06:07.370 Now with min and max, I want men and Macs to be center aligned. 06:07.410 --> 06:10.260 So I'll add another field override this time. 06:10.260 --> 06:13.590 All use of field names with matching rejects. 06:13.960 --> 06:21.700 OK, so the regular expression for that will be a min or max that character in the middle there. 06:21.720 --> 06:27.570 That is a pipe and you'll find that in your keyboard, on my keyboard that is next to the Z key and 06:27.570 --> 06:28.320 you press shift. 06:28.470 --> 06:29.610 That's a pipe character. 06:29.650 --> 06:33.390 OK, so that's my override for min and Max using a rejects. 06:33.480 --> 06:37.740 I'll add the Override Property Column Alignment Center. 06:37.760 --> 06:43.680 OK, so just mean and Macs are now centers, so you have the ability to do all kinds of overrides on 06:43.680 --> 06:44.760 individual columns. 06:45.060 --> 06:47.160 OK, so let's apply that and we can see that. 06:47.160 --> 06:49.330 So that's already quite interesting. 06:49.410 --> 06:52.590 Looking table that's a table visualization. 06:52.770 --> 06:53.520 Very versatile. 06:53.910 --> 06:54.300 Excellent.