Increment by 1 Every 15 Rows

Hello,

So basically I have data that I need to group together, but have nothing that would explicitly group it together other than the Row Number. I need to group together every 15 rows and increment it by one. I've included an image below of what I'm looking to do. Any help would be greatly appreciated. Thank You

Every 15.PNG

Workflow

Datasets

Tips and Tricks

Tableau

Dynamic Processing

Interface Tools

Accepted answers

BenMoss

You can use the following formula if you have a row number already...

CEIL([RowNumberField]/15)

Basically devide the row number by 15 and then round to the nearest whole number.

Ben

All comments

Claje

Hi,

Try the following formula:

FLOOR(([Record Number]-1)/15)+1

This will take the record number (minus 1 because we want the 15th record to still be ID 1), and divide it by 15. It will then find the floor, which is the nearest integer (rounding down).

Then we add one to this so that it starts at 1 instead of zero.

BenMoss

You can use the following formula if you have a row number already...

CEIL([RowNumberField]/15)

Basically devide the row number by 15 and then round to the nearest whole number.

Ben

Claje

Just wanted to reply and say that @BenMoss has the more elegant formula. CEIL() is definitely more appropriate than FLOOR() and avoids some of the addition/subtraction I was using.

rjanezic

Oh wow that's really interesting. Definitely wouldn't have thought of that. Thank You!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703