How to get a variable based on if condition using iron python script

[Sabari Vishnu Jayanthan Jaikrishnan]

I would like to get the number of unique ids where the move type is 1. I know this can be done easily in iron python but I am stuck in this step.

 

from Spotfire.Dxp.Data import *

# getting the data table

tableName = 'table_name'

table = Document.Data.Tables[tableName]

# getting the column

column = 'MOVETYPE'

 

I don't know how to proceed further. I am expecting something like

if (movetype == 1):

unique_ids = len(set(list(id)))

and show this unique_ids in a text box chart in the dashboard.

 

Could anyone please kindly help me here (i am using spotfire 7.11 version)

 

or is there any way to achieve this without iron python

 

Thanks in advance :).