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:

• Press Sheet 1
• Press 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 dropdown at the All section on Marks Card
• Optionally add drop lines

Results