Often, it can be handy to have row numbers when viewing data in tabular form. Let's take a look at how we can calculate row numbers in the Data Pipeline in order to generate a table similar to the following:
We'll open our chart in the Chart Editor, click the + button in the Data Pipeline, and choose Add Column.
We'll choose "Custom formula" as our Formula Type, and enter the following into the Formula field:
That's it! If you want your Row id column to be the first column, simply add a Reorder Columns step.