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

[Maksym2]

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

[ErikG]

Hi @Maksym2
check out

How to create a column with serial no or row number?

I have to create a column called ROWS which is nothing but serial no or the row number . how we can create it in quicksight , can anyone help please. Actually I do have 38 columns in the dataset so want correct way to do it . Can anyone please help me out

BR

[Brett]

Hi @Maksym2,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Biswajit_1993]

Hi @Maksym2 ,

Could you please check with this solutions.

How to add a new column in (Row ID) which is sequentially increasing

Hi @Biswajit_1993 - Sure, here’s the calculated field and example. row_id rank([concat({column_name},{data_item_descr}, attr) ASC],[],PRE_AGG) [image]

Thanks & Regards
Biswajit Dash