Value Aggregation


Display the minimum exports each year.

Data Source

  • Table: bi.ex_net1.m


  • Drag-and-drop the table to Canvas area
  • Click Sheet 1
  • Click OK to acknowledge the warning about limitations
  • Drag-and-drop Value to the Marks Card, right click > Measure > Minimum, replace Detail with Size
  • Drag-and-drop Datetime to the Marks Card, replace Detail with Color
  • Drag-and-drop Datetime to the Marks Card, right-click on the QUARTER > YEAR, replace Detail with Label
  • Change Automatic to Circle in the dropdown at Marks Card


In year 1975 the value was equal to 109 which is the minimum of all values for the bi.ex_net1.m metric: