This is a thread of phrases similar to “a few sandwiches short of a picnic” from around the world, starting with this one…
There’s a colourful old Swedish idiom that goes hjulet snurrar men hamstern är död. It means “the wheel is spinning but the hamster is dead”