I basically want to create a row id for my table, where it increments by 1. This count should be based off of each ResultID in the table. So if there are 5 ResultID 's in the table, the row id should be 1-5. How do i do this?

Hi @HarveyB-B please have a look at [image] How to add a new column in (Row ID) which is sequentially increasing Question & Answer Hi @Biswajit_1993 - Sure, here’s the calculated field and example. row_id rank([concat({column_name},{data_item_descr}, attr) ASC],[],PRE_…

This doesn’t seem to work for me. rank([concat(ResultID,ResultDesc) ASC],,PRE_AGG) ResultID is a case number, and the ResultDesc is whether they were accepted or denied. I have filtered to accepted since this is what i am looking at. I have a table showing Row ID, date, ResultID, ResultDesc, Resu…

Hello @HarveyB-B and @ErikG ! @HarveyB-B were you able to find a workaround for this or are you still running into this problem? If you were able to find a solution could you share it to help the community? Maybe I am missing something, but can you break down which field you would like to base the…

Hi there, thanks for the response. i’m no longer needing this post so feel free to archive.

No problem @HarveyB-B ! If you were able to find a workaround or solution do you mind sharing it to help the community?

Creating a Row ID based on field

Q&A

ErikG January 25, 2024, 10:24am 2

Hi @HarveyB-B
please have a look at

Topic		Replies	Views
How to add a new column in (Row ID) which is sequentially increasing Q&A quick-sight , calculations	4	6870	July 30, 2024
データセット側の計算フィールドで通番を付与したい日本語で質問 \| Q&A quick-sight , Business-Intelligence-Engineer	2	66	October 17, 2025
Serial number Q&A analysis , quick-sight , calculations	4	1229	August 21, 2023
"Static" row numbering in a table visual Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	56	October 16, 2025
Rank PivotTable Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	3	55	February 12, 2025

Creating a Row ID based on field

Related topics