# SUM by Year for Two Metrics

# Overview

Report showing the differences between two metrics on separate graphs.

# Data Source

• Tables: bi.im_net1.m and bi.ex_net1.m.

# Steps

• Drag-and-drop both tables to Canvas area.
• Select Inner Join, specify Time and Entity as equal fields:

• Click Sheet 1
• Click OK to acknowledge the warning about limitations.
• Drag-and-drop Datetime onto the column field.
• Drag-and-drop both Value onto the rows field.
• Select Bar in the drop-down list in the All section on the Marks Card.
• Optionally add drop lines.

# Results