Visokio website     Downloads     Video tutorials     KnowledgeBase  
Uniqueness on multiple fields (within a subset) - Visokio Forums
Uniqueness on multiple fields (within a subset)
  •     schergr April 23, 2012 1:51PM
    Trying to create a formula that gives me a unique count of records where three (or more) fields are used to determine the uniqueness of a record (as is possible with the deduplicate block. Any thoughts on how to do this? Seems that subset_Uniquecount doesn't do it as it only gives a unique count on the one stat field, which is determine by the subset.
  • 3 Comments
  •     chris April 24, 2012 4:07AM
    Hi,

    Can you post some example data so we can get a better idea of what your trying to do?
  •     steve April 26, 2012 4:47AM
    Do you mean that you want to find the number of unique combinations of any number of fields for all values present in the data?

    So:

    COLOUR, NAME, NUMBER
    Pink, Apple, 5
    Green, Apple, 4
    Yellow, Banana, 5
    Green, Pear, 4

    For just COLOUR, it's 3.
    For just NUMBER, it's 2.
    For COLOUR and NAME, it's 4
    For COLOUR and NUMBER, it's 3
    For all, it's 4.
  •     steve April 26, 2012 4:48AM
    If so, you can achieve this by creating a formula field which concatenates the fields using a character that definitely isn't present in your data, e.g. |, ~, etc.

    For example:
    TEMP = COLOUR + "~" + NAME + "~" + NUMBER

    Then use SUBSET_UNIQUECOUNT([TEMP])
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories