In the previous lesson, you added a spreadsheet to a new workbook and used it to create a map card. In this lesson, you'll create new cards that will improve your understanding of the flow map and help you visualize specific relationships. First, you'll create a predefined filter that will allow you to choose which year to analyze. Next, you'll create charts to display the total count of persons of concern in each country of origin and country of residence. Then, you'll create a summary table to compare the number of refugees and the number of internally displaced persons.
Create a predefined filter
The link map you created is currently showing all the data collected by the UNHCR from 1951 to 2017, making it difficult to see any patterns or relationships in the data. A predefined filter can be used to manage the data so that it can be analyzed more effectively.
- If necessary, open your UNHCR Persons of Concern workbook.
- In the data pane, click the Widget drop-down arrow and choose Predefined Filter.
A predefined filter card is added to the page.
- In the Predefined Filter 1 card,
The New Filter pane appears.
- For Filter by, choose Year.
A list of all values in the Year field is added to the pane. The list spans from 1951 to 2017. You can add the values individually or by groups.
- Click By value.
The Predefined Filter 1 card is updated with the years 1951 to 2017. The boxes can be selected to filter data to the selected years.
- Rename the Predefined Filter 1 card to Year.
- Drag the Year card header below the Migration of persons of concern card.
The data you are using from the UNHCR gives the total number of persons of concern for each year, rather than the new persons of concern for each year. For example, a person who is documented first as a refugee in 2015 could be counted as a refugee again in 2016 and 2017 if his or her status has not changed. Therefore, it is important to avoid any analysis that aggregates data from multiple years, because you'll end up with artificially high totals. The filter settings can be used to ensure that only one year can be chosen at once.
- If necessary, click the Year card to access its toolbar. Click the More button and click the Card Settings button.
The Card Style pane appears.
- Click the Selection Properties tab.
The Selection type options are displayed. By default, Multi select is enabled.
- Click Single select.
The Selection type changes so that only one year can be selected at a time.
- Close the Card Style pane.
The filter is updated to a single select layout, with 1951 chosen by default. The flow map is updated to show several nodes that are the same size, but with no link connections. The reason for this change is because the UNHCR did not collect data on country of origin until 1960 (the origin is recorded as Various/Unknown).
- In the Year card, click 2017.
The map updates to show the persons of concern from 2017.
If you receive an error message, try clicking a different year and then clicking 2017 again.
- Save your workbook.
Add charts and tables
The predefined filter has made some aspects of the link map clearer. However, there is still a lot of information that you cannot learn from the map. For instance, you can use the flow map to determine which countries accepted refugees from many countries, but it's not possible to tell which countries have the largest number of persons of concern. Chart and table cards can supplement the flow map and make your analysis more effective. For the purpose of your story, it will be important to know where persons of concern are living.
To understand which countries have the greatest number of persons of concern, you'll add chart and table cards to the workbook.
- In the data pane, under Person of Concern.Table1, select the Country / territory of asylum/residence and Total Population fields (press Ctrl to select both at once).
- Drag the selected fields to the empty space next to the map card, point to the Chart drop zone, and choose Bubble Chart.
A bubble chart is created. It shows the population of persons of concern in each country of residence. Like the link map, it is filtered by the predefined filter.
- Rename the bubble chart card to Country of residence.
If your filter is set to 2017, the bubble chart shows that Colombia and Syria are the countries with the highest total populations of persons of concern.
- Click the bubble for Colombia (Colom).
The link map updates to show the nodes and links where Colombia is the country of residence. The thickest line both originates in and points to Colombia. The rest of the lines are thinner, so it's difficult to know how many people are coming from the other origin countries. You'll need to create another chart for the country of origin.
- Click Colombia again to deselect it. Click the empty space next to the bubble chart card to deselect it.
- In the data pane, under Persons of Concern.Table1, select the Origin and Total Population fields. Drag the selected fields to the empty space next to the bubble chart, point to the Chart drop zone, and choose Column Chart.
You can change which statistics are displayed on the chart using the Chart statistics button on the card toolbar. You can even remove all statistics.
- Rename the column chart Country of origin. Click the card to select it and drag the sides or corners of the card to increase the card's width.
- On the bubble chart, select Colombia.
Some of the columns on the column chart fade out. The columns that remain indicate countries that have persons of concern residing in Colombia. However, the chart still doesn't show the number of people from each country of origin that are residing in Colombia, only the total number of persons of concern for each country, regardless of where they reside.
To understand the flow of migrants at the country level, you'll need to apply a cross filter. A cross filter will filter your cards based on selections on other cards.
- On the bubble chart and column chart toolbar, click the Enable cross filters button.
The column chart is filtered to show the persons of concern living in Colombia from each country of origin.
- Point to the bars to see the number of persons of concern.
The other countries' bars appear to have disappeared. Actually, the bars are too small to see in comparison to the Colombia column. There are over 7 million persons of concern from Colombia residing in Colombia. The country with the next highest number of persons of concern living in Colombia is Venezuela, with about 70,000.
- On the bubble chart, deselect Colombia.
The filter is removed from the column chart. The tallest column on the chart is Syria. In 2017, Syria had the highest total persons of concern for any country of origin, over 12 million.
- Select the Syria column.
Point to a column to see the name of the country.
The link map reflects the selection, and the bubble chart is filtered because of the cross filter.
You can also apply the cross filter to the link map. A cross filter will make the map easier to read, but it will also change the nodes so that they are all the same size.
According to the bubble chart, Syria is the country of residence with the most persons of concern from Syria, which implies that internally displaced persons make up a large portion of the total population. However, as a reporter, it is important that you work with facts, not assumptions. To make sure your assumption is accurate, you'll create a summary table.
- Deselect the Syria column. Deselect the column chart.
- In the data pane, select the Origin, Country / territory of asylum/residence, Refugees (incl. refugee-like situations), Asylum-seekers (pending cases), Internally displaced persons (IDPs), and Total Population fields.
Select the fields in the order listed in this step, rather than the order they appear in the data pane.
- Drag the selected fields to the Table drop zone in the empty space next to the Year card.
A summary table is created, but it is hard to read the values. The table will have to be resized.
- Confirm that the table card is selected. Drag the sides to increase the width of the table.
The data is easier to read.
Some of the headings are truncated because they're too long. If you want to update the field names, you can do so by editing the field name in the data pane.
- Rename the table card to Refugees, asylum seekers, and internally displaced persons.
- Select the table card. On the toolbar, click the Enable cross filters button.
- Save the workbook.
In this lesson, you created a predefined filter, charts, and a summary table that can be used to examine the data and learn more about persons of concern. In the next lesson, you'll use these cards, including the flow map, to analyze and interpret the movements of persons of concern by looking for patterns and discrepancies in the data.