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

Question & Answer
,
1

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

2

Hello @Samiksha,

Welcome to the Community! Thank you for your question. Unfortunately, QuickSight doesn’t provide a built-in feature to add row numbers directly. It seems that you want to include row numbers in a pivot table or table as rows, which implies that it should be a dimension without custom aggregate levels. Nonetheless, please check out the link below; it might offer a solution to your problem. Thank you!

Can you try to create a calculated field using the runningCount function - runningCount(, [1 ASC], ).

1 Like
3

using this as is - runningCount(, [1 ASC], ) giving me syntax error . DO I need to use as is or need to add any column for sorting or just the same ?

4

Hello @Samiksha

You to alter the syntax of calculation field with your dimension or fact fields to rank it. Here is the example.

Example ROW_NUM - runningCount(Date, [Date ASC])

image

image
image298×566 23.7 KB

2 Likes
5

Actually I tried using this - rank([{DATE} ASC],,PRE_AGG) and it worked for now I tried runningCount as well but the syntax I was giving as runningCount({Date}, Date ASC), so this was wrong.

Thanks for helping me . Could you please tell me that which is appropriate out of these two ??

2 Likes
6

Hi @Samiksha,

It’s a matter of preference. From a performance perspective, you might prefer using rank and PRE_AGG. For simplicity and ease of understanding, runningCount might be better. There’s no right or wrong answer; it all depends on your specific data decision needs.

2 Likes