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:
- 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, …
- Some time there can be a missed (null) value in dataset for each column.
- The calculated metric also can be filtered through analysis filters (not only from dataset parameters).
Regards,
Maksym