Average by Year for One Metric
Build a report illustrating average monthly imports each year.
- Drag-and-drop the table to Canvas area
- Click Sheet 1
- Click OK to acknowledge the warning about limitations
Datetimeonto the columns field.
Valueonto the rows field.
- Change value aggregation from SUM to AVG: right-click > Measure > Average
Linein the drop-down list on Marks Card
- Optionally add drop lines