To preview the effect, hold down the Right Mouse Button in the Material preview viewport and move the mouse up and down to zoom in and out. When the camera is 512 units away from the sphere, the Material will transition from brick to gravel. If you can't see this happening, you can adjust the value in the Constant plugged into the Divide node. Reducing the value from 512 to something smaller will cause the transition to occur sooner.