9. Dashboards

Time to bring everything together. Let’s build our first dashboard. At the top, go to Dashboard -> new Dashboard. This brings up a new screen with a list of all worksheets and a few other options.

First, let’s change the dashboard size, from a fixed size to automatic.

9.1. Add the map and the chemical list table.

Notice all of the worksheets we've created are shown on the left side of the screen. Let’s drag our map to the middle of the screen:

Let’s also add that chemical list to the left side of the screen:

9.2. Actions

Now we can do something really cool – we’ll add an Action that allows us to click on a chemical in the table, and only show facilities that release that chemical on the map

We'll add an action, so that if you click a chemical on the table, the map only shows the facilities that release that specific chemical. Go to Dashboard -> Actions…

We want to add a Filter action:

Here, I’m naming the action “Select facilities by chemical”. I want to run the action on select, when I select from the Chemical table sheet. I want to target all sheets, and show all values of the chemical I select.

When all that is set up, click okay and try selecting a chemical on the table:

So, clicking a chemical filters the facilities shown on the map to only those emitting the selected chemical. (To deselect a chemical, just click on the "Chemical" header at the top of the table).

9.3. We’re missing an important piece of information, though. Which industries emit what? And at what intensity?

Let’s make one final worksheet to get at this data. Create a new worksheet.

Let’s build a tree map this time. Put our “Total releases” Measure on Mark Size and Industry group Dimension on mark label:

Here, the area of each square is proportional to that industry’s total releases. Now, let’s add color. Add another total releases to color, but switch it to an AVG.

Let’s also add total releases to label, and configure that a bit more. (edit label by left-clicking to add some detail)

Finally, let’s add the tree map to our dashboard, below the chemical list:

SUBPAGES (10): 1. INTRODUCTION 2. CREATING 2-D GRAPHS 3. 3-D GRAPHS AND MORE! 4. MAPS 5. MERGE IN EIA POWER PLANT DATA 6. DOES THE AMOUNT OF ELECTRICITY GENERATED INFLUENCE GHG EMISSIONS? 7. CALCULATED FIELDS 7. CALCULATED FIELDS 8. TRI DATASET & TABLE CALCULATIONS 9. DASHBOARDS