How to Calculate Row Number Using the Data Pipeline

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:

rowid

That's it! If you want your Row id column to be the first column, simply add a Reorder Columns step.