Look at something called transform, so it's quite a brand new dashboard, empty panel, and that's
the transforms tab of just their transformations led to join, calculate, reorder, hide and rename
your query results before they are visualized.
Okay, so for this, we'll update our query.
We'll need to time series in order to do a transform on them.
So it's duplicate a.
So we have two random walks now.
Very good.
Okay.
And refresh that just so that we can see them both.
So I embedded both random walk and I go back in to transform.
Now, the most common transform that you'll probably use is add field from calculation.
Now, by default, this will just add both of those values and create a third time series.
So I guess that's done that.
So it's just taken both of those rows, a series and B series and added them together.
Now we didn't actually make any decisions there, so we can be more explicit about what we want.
So instead, I will do binary option field a plus minus multiply divided by etc with B, so a series
plus B series.
And that's the same thing, really.
It's just taken A and B and creating a new one, which is called a Series Plus B series, we can call
that anything we like, such as total.
It's been updated to B Total now.
We can also replace all fields, so it only just shows the total now, so total bang that.
So I want to see all of them.
OK, that's good.
We can apply that.
And that's a very quick dashboard build up of two time series and the third one being the addition of
both.
Let's edit that.
Going back in to transform that.
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
explicit about what we're using calculation.
Oh, use the mean being average.
So we'll call that mean this time.
And that blue line is now the average of those two lines.
So I could have had three time series there, replace all fields once again, just shows the one line
or keep them all.
So apply that.
And then we go.
Now the blue line is just shown the average so that common transforms you might like to try.
I'll show you one more transform.
So instead of modifying this panel, let's duplicate it.
Duplicate is to cut to the right.
They're random walks, so they will always show random data.
So every time I refresh, it's just a little bit different.
Also something that I'm sure.
Yet this five seconds here will refresh every five seconds.
Just one.
Yes, no.
But we don't need that anyway.
I said at that panel, so easy to edit.
Now if we look at the transform, we have the existing transform because we duplicated it from the panel.
I'm going to add a second transform here and that is going to be called reduce.
So reduce all rows or data points to a single value using a function like Max Minamino lost.
OK.
It doesn't work on the graph visualization, so we need to view it as a table so we can press the table
view there and we can see the data as a table.
But actually, when we save this, for example, if I apply that now, it's showing me that doesn't
have a time field.
So if we go back into it and instead of using time series up there, we select Table.
OK, it's now showing us as a table by default, whether or not we have that selected or not now apply
and we can say as a table.
Anyway, let's continue to edit that.
Now the transform, the options, we have series two rows or reduce fields into a single value.
I'm going to use series two rows.
And for the calculations, I want to show the last value, the first value, the difference.
And.
That's pretty good.
We can see that, so our table up here has a lot of extra information in this is random, so it's not
really that useful, but it could be useful data.
So apply that we go we have a graph and a table along sort of summarizes all the information that would
be in the same graph.
I and this is random walks.
That's all random.
So but anyway, and refresh that as well.
Excellent.
So they are really what transformations are about taking something that you already have and applying
some transformation over top of it to create a new set of information?
Excellent.
So if you want to find out more about transformations, you can visit the Gafah Transformations page
and it's quite in-depth.
So it's a lot of information to take in if you try to read the documentation this way, but I'll show
you a couple of ways of using those probably the most common ways you do use those things anyway.
OK, so excellent.