Support Import

Configuring a Calculated Fields

In this example, we will create three calculated fields that we will use later.

By right clicking on the entries pane, we are going to create a calculated field so that to view the Continent in which the expense in each KPI was updated. Note, that the continent was not in any of the dimensions.

As we know the cities that are being used (Dimension 2), we will set an expression so that to deduce the continent according to every city.

For example, if the city is Athens or Berlin, the Continent is Europe while if the country is Sao Paulo, the Continent is South America.

calculatedfield.png

Except from the Continent, we will create the "Sum" calculated field so that to be able to add the amounts (Dimension 4) of each transaction.

calculatedfield2.png

Last but not least, we will create the "Date" calculated field so that to be able to get the details of the date according to the datetime (Dimension 3) imported.

calculatedfield3.png