Search code examples
spotfire

spotfire uniquecount in an one to multiple table


I have a table where one id has multiple entries. For each id, as long as there is an entry where mark is "1", it is considered marked. i want to know how many ids are marked. in this case there are 2.

thank you

click here to view my table


Solution

  • This seems like what you want...

    UniqueCount(If([Mark] = 1,[ID]))