That really is how long is a piece of string question. There is rocker profiles for narrow boards and different ones for wider boards . Then you have tail and nose rocker. There is no magic formula in sups because you can't compare to a shortboard. If you can't stand on it or paddle fast enough to catch a wave it's too narrow or too much rocker. So sometimes they flatten the rocker to give more paddle speed and then pull in and turn up the nose and tail and keep the width for stability.
This will give both of best worlds but your board will look like a Barbecued sausage. Progressive design is more rocker profile with extra nose and tail lift on a narrower board with more pulled in nose and tail. Boom the perfect board but you can't stand on it or catch waves.
This is where you have to look at all the designs and take into account your height , weight and ability plus where you want to surf it. So here is the magical formula you might be after:- L = Litres you need + A = Ability out of 10 +W= Weight kg's + S = Surf conditions.
L+A+W+S ,
for me = ("L" min 105 + Ability 7 + "W" 88kgs , "S" Surf Beach breaks & Bombies)
For me this comes out to the JP 2015 8-6 , yes there are plenty of other boards that will suit but this video gives a good insight to why I ride what I do. Feel free to post other videos of other brands.