How do I display simple row number for each row in quicksight table visual?

How do I display simple row number for each row in quicksight table visual?

Just a column named “№” which represents the row number.

Or is there an option to create a calculated metric that can represents it with options:

  1. The data for each column can be filtered, so, for example, if I do runningCount({column_1}, [{column_1} ASC]) formula, if some values are filtered it will show irrelevant numbers like 1,2,3, 6, …
  2. Some time there can be a missed (null) value in dataset for each column.
  3. The calculated metric also can be filtered through analysis filters (not only from dataset parameters).

Regards,
Maksym

Hi @Maksym2
check out

BR

1 Like