Incremental RowId over the Same Category and Repeat

[Kok Leong Foong]

Guys, if I want to get "Required Column" and "Required Column 2", how can I do that in Spotfire

[James Watts]

What is it that causes the "Req Col 2" to change from 1 to 2

[Kok Leong Foong]

Hello, I would like to make it such that if the same category appear again, it will be numbered 2, so on and so forth.

[James Watts]

Create the following columns

[Row ID] = RowId()

[Previous Category] =Concatenate([Categories]) over (Previous([Row ID]))

Flag =If(([Previous Category][Categories]) or ([Row ID]=1),1,0)

[Required Column 2] =Sum([Flag]) over (Intersect([Categories],AllPrevious([Row ID])))

[Required Column] =Count([Categories]) over (Intersect([Categories],AllPrevious([Row ID]),[Required Column 2]))