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

[Maksym2]

Greetings @Biswajit_1993 @ErikG @Brett

I am sorry for late response.

The solution that you showed me is not fitting my case because of filters and also I do not have always date. Also, we should keep in mind that if we change the sorting, the row numbers will be shown in irrelevant order.

Maybe it is could be a simple improvement from QS? To pivot tables, table widgets add a setting to show row number column at the start.

Regards,
Maksym

[Brett]

Hi @Maksym2,
So ideally, you’d like a row number column where the values shift their ranking based on how your filter/sort, not a pre-defined field?

I can mark this as a feature request as there is not a simple out of the box solution for this.

Let us know if you have any additional questions!

[Brett]

Hi @Maksym2,
Since I’ve marked this as a feature request already and there has been no additional activity on this thread, I’ll go ahead and close out this post. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!