Is Unique

Chris DownerChris Downer Experian Contributor
edited October 2019 in Data Studio best practices

I've had a few questions around checking if a value is unique in a column.

Voila:

(Thanks @Ian Thornton )

Comments

  • Clinton JonesClinton Jones Experian Super Contributor

    In v2 you could make this into a reusable function

  • Akshay DavisAkshay Davis Administrator

    @Ian Thornton @Chris Allan does the lookup cache the results of the first time the count is run, or does it perform the count for each row? Is this the same, more or less efficient than grouping on the surname field, counting the occurrences and joining the results back to the original?

Sign In or Register to comment.