All language subtitles for 001 Introduction to Measures Section_en

Welcome to this section on measures.

So in the previous section, we saw how we created a calculated column.

What you saw was that in the table we got a new field and that field actually had a result for each

row that was actually in the table.

Now, when it comes to measures, measures are different.

We don't actually create a new column that's going to be part of the table.

What we do is we create a new calculation, and that calculation is then applied to the context of visualization.

So you're going to see in the section how we can actually then create those measures, bring them into

our calculations and allow them to be performed within visualizations.

You're going to see that a number of these types of calculations are often aggregates that we can use.

We can use a sum and average max.

So we're going to use some examples of that.

We're also going to be introducing a couple of new functions, such as distinct count and divide.

I'm going to be seeing how we can use those in our calculations.

We then also going to introduce a new function called Equal to calculate.

So you're going to see with equals calculate.

It's very much like a filter that you can apply to an expression.

So if you've used equal to some F or average F or count F in Excel, then basically what you did was

you said some of these amounts.

If a certain condition is met and you're going to see that equals calculate allows us to be able to

do something similar, but we can have filters that are applied to an expression.

But we're going to explain in the lessons how this works in more detail.

So yet again, let's jump into the lessons and I will see you there.