# MIN and MAX by Year for One Metric

# Overview

Report comparing minimum and maximum exports per year.

# Data Source

• Table:bi.ex_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 aggregation from SUM to MIN: right-click > Measure > Minimum
• Drag-and-drop Value onto the rows field, change aggregation from SUM to MAX: right-click > Measure > Maximum
• Select Line in the drop-down list in the All section on the Marks Card
• Optionally add drop lines

# Results