What is the link between foam, concentration of water-based coolant and water hardness?
The higher the concentration the higher the quantity of surfactants. The surfactants will stabilize the foam.
The lower the hardness the lower the quantity of ions which react with surfactants.