Adding row numbers to a table with a Beast Mode?

Is there a way to add row numbers to a table with a Beast Mode? So there would be a column to the left of Date with a 1. for 2020-09-01, a 2. for 2020-09-08, etc?

Screen Shot 2020-10-15 at 3.20.00 PM.png

Find more posts tagged with

Accepted answers

GrantSmith

Hi @Joe_M

You can utilize a windowing function (if you don't have it enabled in your instance, talk to your CSM to get the feature switched on) within a beast mode.

SUM(SUM(1)) OVER (ORDER BY `Date`)

This is calculating the row number based on the `Date` field, if you need to calculate it based on another field change `Date` in the beast mode.

All comments

GrantSmith

Hi @Joe_M

You can utilize a windowing function (if you don't have it enabled in your instance, talk to your CSM to get the feature switched on) within a beast mode.

SUM(SUM(1)) OVER (ORDER BY `Date`)

This is calculating the row number based on the `Date` field, if you need to calculate it based on another field change `Date` in the beast mode.

Joe_M

Awesome! Thank you.