Found the answer. Leaving it here if anyone finds helpful:

    {
      "name": "highestSales",
      "update": "extent( pluck( data( 'dataset' ), 'Sales Total' ))[1]"
    }

The pluck function returns a column as an array, and the extent function returns an array containing the minimum and the maximum of the given array.