1
00:00:00,570 --> 00:00:06,450
Look at something called transform, so it's quite a brand new dashboard, empty panel, and that's

2
00:00:06,450 --> 00:00:12,930
the transforms tab of just their transformations led to join, calculate, reorder, hide and rename

3
00:00:12,930 --> 00:00:15,060
your query results before they are visualized.

4
00:00:15,150 --> 00:00:18,210
Okay, so for this, we'll update our query.

5
00:00:18,210 --> 00:00:22,490
We'll need to time series in order to do a transform on them.

6
00:00:22,500 --> 00:00:23,880
So it's duplicate a.

7
00:00:23,920 --> 00:00:25,890
So we have two random walks now.

8
00:00:25,950 --> 00:00:26,530
Very good.

9
00:00:26,550 --> 00:00:27,030
Okay.

10
00:00:27,030 --> 00:00:29,750
And refresh that just so that we can see them both.

11
00:00:29,760 --> 00:00:33,450
So I embedded both random walk and I go back in to transform.

12
00:00:33,480 --> 00:00:39,690
Now, the most common transform that you'll probably use is add field from calculation.

13
00:00:39,690 --> 00:00:45,430
Now, by default, this will just add both of those values and create a third time series.

14
00:00:45,450 --> 00:00:47,160
So I guess that's done that.

15
00:00:47,160 --> 00:00:51,900
So it's just taken both of those rows, a series and B series and added them together.

16
00:00:52,140 --> 00:00:56,680
Now we didn't actually make any decisions there, so we can be more explicit about what we want.

17
00:00:56,700 --> 00:01:05,790
So instead, I will do binary option field a plus minus multiply divided by etc with B, so a series

18
00:01:05,790 --> 00:01:07,020
plus B series.

19
00:01:07,020 --> 00:01:08,690
And that's the same thing, really.

20
00:01:08,690 --> 00: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

21
00:01:14,730 --> 00:01:17,340
that anything we like, such as total.

22
00:01:17,700 --> 00:01:19,380
It's been updated to B Total now.

23
00:01:19,380 --> 00:01:24,810
We can also replace all fields, so it only just shows the total now, so total bang that.

24
00:01:24,810 --> 00:01:26,160
So I want to see all of them.

25
00:01:26,160 --> 00:01:27,540
OK, that's good.

26
00:01:27,570 --> 00:01:28,680
We can apply that.

27
00:01:28,680 --> 00:01:35,550
And that's a very quick dashboard build up of two time series and the third one being the addition of

28
00:01:35,550 --> 00:01:35,940
both.

29
00:01:36,150 --> 00:01:37,200
Let's edit that.

30
00:01:37,710 --> 00:01:39,150
Going back in to transform that.

31
00:01:39,150 --> 00: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

32
00:01:45,690 --> 00:01:48,030
explicit about what we're using calculation.

33
00:01:48,120 --> 00:01:50,490
Oh, use the mean being average.

34
00:01:50,490 --> 00:01:52,800
So we'll call that mean this time.

35
00:01:53,310 --> 00:01:57,030
And that blue line is now the average of those two lines.

36
00:01:57,030 --> 00:02:02,250
So I could have had three time series there, replace all fields once again, just shows the one line

37
00:02:02,250 --> 00:02:03,420
or keep them all.

38
00:02:03,420 --> 00:02:04,740
So apply that.

39
00:02:04,890 --> 00:02:05,520
And then we go.

40
00:02:05,640 --> 00:02:09,840
Now the blue line is just shown the average so that common transforms you might like to try.

41
00:02:09,870 --> 00:02:11,100
I'll show you one more transform.

42
00:02:11,110 --> 00:02:14,790
So instead of modifying this panel, let's duplicate it.

43
00:02:15,480 --> 00:02:17,610
Duplicate is to cut to the right.

44
00:02:17,610 --> 00:02:20,430
They're random walks, so they will always show random data.

45
00:02:20,460 --> 00:02:23,130
So every time I refresh, it's just a little bit different.

46
00:02:23,490 --> 00:02:25,160
Also something that I'm sure.

47
00:02:25,180 --> 00:02:28,470
Yet this five seconds here will refresh every five seconds.

48
00:02:31,200 --> 00:02:31,740
Just one.

49
00:02:38,780 --> 00:02:39,290
Yes, no.

50
00:02:39,980 --> 00:02:41,150
But we don't need that anyway.

51
00:02:41,180 --> 00:02:43,460
I said at that panel, so easy to edit.

52
00:02:43,560 --> 00:02:49,120
Now if we look at the transform, we have the existing transform because we duplicated it from the panel.

53
00:02:49,130 --> 00:02:55,100
I'm going to add a second transform here and that is going to be called reduce.

54
00:02:55,220 --> 00:03:01,310
So reduce all rows or data points to a single value using a function like Max Minamino lost.

55
00:03:01,820 --> 00:03:02,030
OK.

56
00:03:02,540 --> 00: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

57
00:03:08,780 --> 00:03:10,700
view there and we can see the data as a table.

58
00:03:10,700 --> 00:03:16,010
But actually, when we save this, for example, if I apply that now, it's showing me that doesn't

59
00:03:16,010 --> 00:03:16,850
have a time field.

60
00:03:16,850 --> 00:03:21,890
So if we go back into it and instead of using time series up there, we select Table.

61
00:03:22,050 --> 00: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

62
00:03:27,260 --> 00:03:28,610
and we can say as a table.

63
00:03:28,670 --> 00:03:30,090
Anyway, let's continue to edit that.

64
00:03:30,350 --> 00:03:37,330
Now the transform, the options, we have series two rows or reduce fields into a single value.

65
00:03:37,340 --> 00:03:38,750
I'm going to use series two rows.

66
00:03:38,750 --> 00:03:45,050
And for the calculations, I want to show the last value, the first value, the difference.

67
00:03:45,440 --> 00:03:46,070
And.

68
00:03:47,140 --> 00:03:48,040
That's pretty good.

69
00:03:48,460 --> 00: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

70
00:03:54,850 --> 00:03:57,840
really that useful, but it could be useful data.

71
00:03:57,850 --> 00:04:04,270
So apply that we go we have a graph and a table along sort of summarizes all the information that would

72
00:04:04,270 --> 00:04:05,230
be in the same graph.

73
00:04:05,230 --> 00:04:06,790
I and this is random walks.

74
00:04:06,790 --> 00:04:07,540
That's all random.

75
00:04:07,550 --> 00:04:10,180
So but anyway, and refresh that as well.

76
00:04:10,210 --> 00:04:10,660
Excellent.

77
00:04:10,720 --> 00:04:16,209
So they are really what transformations are about taking something that you already have and applying

78
00:04:16,209 --> 00:04:20,589
some transformation over top of it to create a new set of information?

79
00:04:20,620 --> 00:04:21,190
Excellent.

80
00:04:21,250 --> 00:04:26,140
So if you want to find out more about transformations, you can visit the Gafah Transformations page

81
00:04:26,140 --> 00:04:27,610
and it's quite in-depth.

82
00:04:27,940 --> 00: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

83
00:04:32,200 --> 00:04:37,180
you a couple of ways of using those probably the most common ways you do use those things anyway.

84
00:04:37,270 --> 00:04:38,320
OK, so excellent.