Compute using

The graph from the previous exercise calculates the percentage difference from year to year, which means that the value for each year is being computed relative to the previous year. We can ask Tableau Public to calculate the percentage difference from different years by clicking on the Context menu for a table calculation of this type, and then selecting Relative to. We can calculate the change from the first, next, previous (the default one), or last values in a partition.

In the following graph, which is a revision of the previous one, the bar height for each year shows the aggregated percentage difference in Remittances per Capita since 1980, which is the first year in the visualization. You can do this by performing the following steps:

1. Click on the Context menu for the Remittances per Capita field on the Rows shelf.

2. Click on Relative to.

3. Select First, as shown in the following screenshot:

   

Then, perform the same calculation on GDP (current USD). We changed its use on the Rows...