# Average by Year for One Metric

# Overview

Build a report illustrating average monthly imports each year.

# Data Source

• Table: bi.im_net1.m

# Steps

• Drag-and-drop the table to Canvas area
• Click Sheet 1
• Click OK to acknowledge the warning about limitations
• Drag-and-drop Datetime onto the columns field.
• Drag-and-drop Value onto the rows field.
• Change value aggregation from SUM to AVG: right-click > Measure > Average
• Select Line in the drop-down list on Marks Card
• Optionally add drop lines

# Results