Comparison of Two Metrics in One Bar Graph

Overview

Build a report displaying monthly exports and imports.

Data Source

  • Tables: bi.ex_net1.m and bi.im_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
  • Optionally rename values: right click on Value and choose Rename
  • Show Me Card > side-by-side bars

Enter Ctrl+W and swap columns and rows.

Drop Lines

Add Drop Lines and Labels:

  • Select a column
  • Right click and choose Drop Lines > Show Drop Lines
  • Right click and choose Drop Lines > Edit Drop Lines > Labels > Automatic

Results