WEBVTT 00:00.570 --> 00:06.450 Look at something called transform, so it's quite a brand new dashboard, empty panel, and that's 00:06.450 --> 00:12.930 the transforms tab of just their transformations led to join, calculate, reorder, hide and rename 00:12.930 --> 00:15.060 your query results before they are visualized. 00:15.150 --> 00:18.210 Okay, so for this, we'll update our query. 00:18.210 --> 00:22.490 We'll need to time series in order to do a transform on them. 00:22.500 --> 00:23.880 So it's duplicate a. 00:23.920 --> 00:25.890 So we have two random walks now. 00:25.950 --> 00:26.530 Very good. 00:26.550 --> 00:27.030 Okay. 00:27.030 --> 00:29.750 And refresh that just so that we can see them both. 00:29.760 --> 00:33.450 So I embedded both random walk and I go back in to transform. 00:33.480 --> 00:39.690 Now, the most common transform that you'll probably use is add field from calculation. 00:39.690 --> 00:45.430 Now, by default, this will just add both of those values and create a third time series. 00:45.450 --> 00:47.160 So I guess that's done that. 00:47.160 --> 00:51.900 So it's just taken both of those rows, a series and B series and added them together. 00:52.140 --> 00:56.680 Now we didn't actually make any decisions there, so we can be more explicit about what we want. 00:56.700 --> 01:05.790 So instead, I will do binary option field a plus minus multiply divided by etc with B, so a series 01:05.790 --> 01:07.020 plus B series. 01:07.020 --> 01:08.690 And that's the same thing, really. 01:08.690 --> 01:14.730 It's just taken A and B and creating a new one, which is called a Series Plus B series, we can call 01:14.730 --> 01:17.340 that anything we like, such as total. 01:17.700 --> 01:19.380 It's been updated to B Total now. 01:19.380 --> 01:24.810 We can also replace all fields, so it only just shows the total now, so total bang that. 01:24.810 --> 01:26.160 So I want to see all of them. 01:26.160 --> 01:27.540 OK, that's good. 01:27.570 --> 01:28.680 We can apply that. 01:28.680 --> 01:35.550 And that's a very quick dashboard build up of two time series and the third one being the addition of 01:35.550 --> 01:35.940 both. 01:36.150 --> 01:37.200 Let's edit that. 01:37.710 --> 01:39.150 Going back in to transform that. 01:39.150 --> 01:45.690 The thing we could do is if we put that back to reduce row, I can select A and B again, so we're more 01:45.690 --> 01:48.030 explicit about what we're using calculation. 01:48.120 --> 01:50.490 Oh, use the mean being average. 01:50.490 --> 01:52.800 So we'll call that mean this time. 01:53.310 --> 01:57.030 And that blue line is now the average of those two lines. 01:57.030 --> 02:02.250 So I could have had three time series there, replace all fields once again, just shows the one line 02:02.250 --> 02:03.420 or keep them all. 02:03.420 --> 02:04.740 So apply that. 02:04.890 --> 02:05.520 And then we go. 02:05.640 --> 02:09.840 Now the blue line is just shown the average so that common transforms you might like to try. 02:09.870 --> 02:11.100 I'll show you one more transform. 02:11.110 --> 02:14.790 So instead of modifying this panel, let's duplicate it. 02:15.480 --> 02:17.610 Duplicate is to cut to the right. 02:17.610 --> 02:20.430 They're random walks, so they will always show random data. 02:20.460 --> 02:23.130 So every time I refresh, it's just a little bit different. 02:23.490 --> 02:25.160 Also something that I'm sure. 02:25.180 --> 02:28.470 Yet this five seconds here will refresh every five seconds. 02:31.200 --> 02:31.740 Just one. 02:38.780 --> 02:39.290 Yes, no. 02:39.980 --> 02:41.150 But we don't need that anyway. 02:41.180 --> 02:43.460 I said at that panel, so easy to edit. 02:43.560 --> 02:49.120 Now if we look at the transform, we have the existing transform because we duplicated it from the panel. 02:49.130 --> 02:55.100 I'm going to add a second transform here and that is going to be called reduce. 02:55.220 --> 03:01.310 So reduce all rows or data points to a single value using a function like Max Minamino lost. 03:01.820 --> 03:02.030 OK. 03:02.540 --> 03:08.780 It doesn't work on the graph visualization, so we need to view it as a table so we can press the table 03:08.780 --> 03:10.700 view there and we can see the data as a table. 03:10.700 --> 03:16.010 But actually, when we save this, for example, if I apply that now, it's showing me that doesn't 03:16.010 --> 03:16.850 have a time field. 03:16.850 --> 03:21.890 So if we go back into it and instead of using time series up there, we select Table. 03:22.050 --> 03:27.250 OK, it's now showing us as a table by default, whether or not we have that selected or not now apply 03:27.260 --> 03:28.610 and we can say as a table. 03:28.670 --> 03:30.090 Anyway, let's continue to edit that. 03:30.350 --> 03:37.330 Now the transform, the options, we have series two rows or reduce fields into a single value. 03:37.340 --> 03:38.750 I'm going to use series two rows. 03:38.750 --> 03:45.050 And for the calculations, I want to show the last value, the first value, the difference. 03:45.440 --> 03:46.070 And. 03:47.140 --> 03:48.040 That's pretty good. 03:48.460 --> 03:54.850 We can see that, so our table up here has a lot of extra information in this is random, so it's not 03:54.850 --> 03:57.840 really that useful, but it could be useful data. 03:57.850 --> 04:04.270 So apply that we go we have a graph and a table along sort of summarizes all the information that would 04:04.270 --> 04:05.230 be in the same graph. 04:05.230 --> 04:06.790 I and this is random walks. 04:06.790 --> 04:07.540 That's all random. 04:07.550 --> 04:10.180 So but anyway, and refresh that as well. 04:10.210 --> 04:10.660 Excellent. 04:10.720 --> 04:16.210 So they are really what transformations are about taking something that you already have and applying 04:16.210 --> 04:20.590 some transformation over top of it to create a new set of information? 04:20.620 --> 04:21.190 Excellent. 04:21.250 --> 04:26.140 So if you want to find out more about transformations, you can visit the Gafah Transformations page 04:26.140 --> 04:27.610 and it's quite in-depth. 04:27.940 --> 04:32.110 So it's a lot of information to take in if you try to read the documentation this way, but I'll show 04:32.200 --> 04:37.180 you a couple of ways of using those probably the most common ways you do use those things anyway. 04:37.270 --> 04:38.320 OK, so excellent.