MRIO: Filtering Complex Analyses

INTRODUCTION:

When using Multi-Regional Input-Output (MRIO), with a few Events in a few Regions, it can become cumbersome to understand how the Filters will display your Results.  Here’s a guide on how to use the Filters to see the Results you want to report.

REGIONS & EVENTS:

Let’s walk through an example with three Regions: A, B, and C. Here we have two Events generating Direct Effects to start; both in Region A. These Direct Effects in Region A created Indirect and Induced Effects in all three Regions as illustrated below.

Using MRIO, you can have Events in more than one Region. This example shows how we have Direct Effects now in Region A (Event 1 and Event 2) and Region B (Event 3). Each of these three Events now yields Indirect and Induced Effects in all three Regions.

FILTERING YOUR RESULTS:

The Results screen will default with no Filters applied and in the current Dollar Year. If you apply a Region Filter for Region A, your Results will display the total Effects to Region A as a Result of the analysis. In this analysis there are three Events, two of which occur in Region A. Filtering by Region A in this analysis will display the resulting Effects to Region A due to all three Events in the analysis. 

FILTER REGION A

If you remove the Region Filter for Region A and replace it with a Filter for Region B, you will see total Effects to Region B due to all three Events in the analysis.

FILTER REGION B

Changing the Region Filter to only include Region C will not yield a Direct Effect, as there was no Event that occurred in Region C. You will, however, see Indirect and Induced effects in Region C because of the three events.

FILTER REGION C

If you remove the Region Filter completely and choose Event 1 from the Event Filter, your Results will display the total Effects of Event 1, in all three Regions.

FILTER EVENT 1

Applying the Event Filter for only Event 2 will show the effects of only this Event in all three Regions.

FILTER EVENT 2

Applying the Event Filter for only Event 3 will show the effects of only this Event in all three Regions.

FILTER EVENT 3

If you remove all Event Name and Region Filters and instead Filter your Group Name for Group 1, you will see the impact of every Event in this Group (in this example Group 1 includes Event 1 and Event 2) across all three Regions.

FILTER GROUP 1

Where things start to get complicated is when you add multiple Filters at the same time. You can Filter for any number of Event Names, Group Names, or Regions at the same time. Just be careful to ensure you know what you are seeing when you do so. In the example below, the Filter was set for Event 1 and Region C. Therefore, we are only seeing the Effects of Event 1 on Region C.

FILTER EVENT 1 & REGION C

Written February 19, 2020