We are most fun period of Tableau learning. Because today we will talk about calculated fields. Everything starts with data, but sometime the data can not include what we want. For example suppose that we have world economic data. We have GDP and Population data. But we want to get per capital. In this case we must use calculated field to get GDP per capital data.Such as

sum([GDP])/sum([Population])

That formula gives to us GDP per capital. We can get new data by using calculated field. Calculated field basicly, help to us for customize our data. I assure you that Tablea calculated field is very elegant. Don’t forget to check out below. It is interface of calculated field.

There are many formulas in tableau but we don’t need all of them in the first place. Also when we create a calculated field, its behave like other fields. You can use it while you are visualizing. And you can use it all the marks card option like color, lable, etc.

Learn Some Calculated Fields Definitions

Before we started to creating calculated field also we need to learn some definitions;

Fields: Calculated fields can bring existing fields into the calculation.

Functions: Functions, define operations that can be performed on data, like aggregations,data type conversions, logic and more.

Operators: Operators are shortcuts for more complex functions that are added by manually. (like “/” this)

Parameters: Parameters are variables that can be inserted into calculations to replace constant values.

Comments: Comments can be added to a calculation to provide context for user. These aren’t displayed in the view but can be helpful for annotating calculations.

Calculated fields are powerful function in Tableau. There are many other ways to create different types of calculated fields.For example, you can use different functions, like AVG([GDP]) or you can break up and combine fields. These functionality is vital for your data visualization.

In next article we will do examples about calculated fields. See your for now.

1 comment

Leave a Reply