Kok Leong Foong Posted April 4, 2019 Share Posted April 4, 2019 Guys, if I want to get "Required Column" and "Required Column 2", how can I do that in Spotfire Link to comment Share on other sites More sharing options...
James Watts Posted April 4, 2019 Share Posted April 4, 2019 What is it that causes the "Req Col 2" to change from 1 to 2 Link to comment Share on other sites More sharing options...
Kok Leong Foong Posted April 4, 2019 Author Share Posted April 4, 2019 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. Link to comment Share on other sites More sharing options...
James Watts Posted April 4, 2019 Share Posted April 4, 2019 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])) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now