Visokio website     Downloads     Video tutorials     KnowledgeBase  
Unique values count vs. unique values list - Visokio Forums
Unique values count vs. unique values list
  •     Phillipa March 9, 2012 10:21AM
    Hi,

    Can anyone enlighten me as to the difference between unique values count and unique values list when used as a function.

    I am a little confused with all the different places you can set functions (aggregates, groups, measures, manage fields etc) and exactly how they work.

    Thanks.
    Phillipa
  • 2 Comments
  •     indranildatta March 9, 2012 10:50AM
    Hi Philipa,

    Here's an example of difference between unique values count and unique values list:

    Say we have a column Country with values

    UK
    US
    Germany
    France

    Then unique value count of Country will be 4 and and unique values list will be UK, US, Germany, France.

    Cheers!
    Indranil
    Indranil Datta
    Invizua Limited - www.invizua.com - Dedicated to Media, Marketing Services and Market Research Organisations
    M: +44 7956 470 046 | E: indranil.datta@invizua.com | Skype: indranildatta1 | LinkedIn: www.linkedin.com/in/indranildatta | Twitter: @indranildatta

    Address: Studio 6, 36-42 New Inn Yard, London EC2A 3EY
  •     Phillipa March 9, 2012 1:05PM
    Thanks Inranil,

    It's quite logical really!!!

    Have a great weekend

Welcome!

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

Sign In Apply for Membership