Creating a Row ID based on field

Question & Answer
,
1

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?

2

Hi @HarveyB-B
please have a look at

BR

3

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, ResultID(count). i see that the count isn’t incrementing by 1, it increments by whatever the count of ResultID is.

image

4

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 new row ID field on? For example, do you want to rank the amount of times that a resultID appears?

5

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

1 Like
7

No problem @HarveyB-B !

If you were able to find a workaround or solution do you mind sharing it to help the community?