How to increment variables to build scoring mechanism

[Laurent Willen]

Hello all,

I'm trying to figure out how I could use variables in Spotfire (online version) to build a scoring mechanism and populate a calculated column with the final result.

 

I have a couple of values stored in columns that I would use to evaluate and attribute a score like this:

if column110 then segment2 = segment2+1

...ETC...

 

In the end each "segment" should have a score and I would like to simply display the name of the segment that has the highest score.

 

Ex:

Segment1 has 10

Segment2 has 22

Segment3 has 122

I would display Segment3 as value for the calculated column

Using only "IF" would lead me to a complicated IF structure so I'm more looking for something that looks more like a script.

 

Is there a way to achieve this with Spotfire

 

Thanks