How to Create a Serial Number Field in Bold BI Dashboard

Creating a serial number field in the Bold BI dashboard can be achieved in two ways: using an expression or using the Code View. Follow these steps for each method.

Method 1: Using an Expression

1. Open the expression dialog.

2. Create a new expression with `ROW_NUMBER() OVER(ORDER BY SUM([Column_Name]) DESC)` and save it.

3. Bind the expression to the widget.

Method 2: Using the Code View

1. Edit the data source to which you want to add a serial ID.

2. Switch to the code view using the toggle button in the toolbar.

3. Add the query `ROW_NUMBER() OVER (ORDER by [Column_Name]) AS [Serial Number].`

4. Click Run and ensure the data preview is correct.

5. Save the data source and bind the field to the widget.

By following either of these methods, successfully create a serial number field in your Bold BI dashboard. After binding the field to the widget, it will be rendered as follows.