It can often be handy to have row numbers when viewing data in tabular form to display information or to use in calculations.
Let’s take a look at how we can calculate row numbers in Visual SQL in order to generate a Table chart similar to the one below:
Click Save to add the new column to your result set.
The newly added Calculated Column is given the name “Custom Formula” by default, but you can rename it—for instance, to “Row Id”—for clarity.
If you want your new Row Id column to be the leftmost column in your Table chart, simply use a Reorder Action to quickly move it.
Your Row Id values will start at 1 and are calculated according to the order of your rows at the time you add the Calculated Column.
If you want your Row Id values to populate based on a different row order, just add a Sort Rows Action before adding the Calculated Column to reorder your results.
Once you do this, the Calculated Column with your
rowidformula will automatically be adjusted.
Now you just need to save your chart to save your changes.
Tip! You can use this Row Id column in a number of ways, for example as part of a CASE statement to set conditions depending on the Row Id value or in a Filter Rows Action to include or exclude some rows from your result set.