How to create serial numbers/ row number using Bold BI Expression?

Creating serial numbers for the data can be done using the ROW_NUMBER() function in SQL Server. This function assigns a unique number to each row within the result set, based on the specified sorting order.

Here’s a step-by-step guide on how to create serial numbers in grid tables:

1. Open the expression in the Dashboard Designer page.
   

   

2. Use the below expression to create the serial number in the expression

   ROW_NUMBER() OVER(ORDER BY [Column Name] [ASC/DESC])
   

   Replace [Column Name] with the name of the column you want to sort the data by, and [ASC/DESC] with the sorting order (ascending or descending).

3. Save the expression and use the expression collum to design dashboards.
   

   
   
   
   

Related Articles:

• ROW_NUMBER (Transact-SQL)
• Using ROW_NUMBER() to number rows