SUM by Year for Two Metrics


Report showing the differences between two metrics on separate graphs.

Data Source

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


  • 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.