5 Replies Latest reply on Jul 14, 2016 12:26 AM by Łukasz Majewski

    Number of common UIDs between years

    Vasileios Kagklis

      Hello everyone,

       

      I have some records and two of the dimensions are: registrationYear and UID. For each year, a number of different UIDs appear.

      The same UID can appear in combination with a different year. The UIDs are strings.

      I place registrationYear in column and row, and the COUNT(UID) in the Label.

      This setup gives me a value only in the diagonal of the table! What I want to do is have a table as the following:

       

                2003 2004 2005 2006 ...

      2003

      2004                        X

      2005

      2006

       

      with all the cells filled with the number of UIDs that are common between the 2 years. For example, in the first cell (2003, 2003) I want the number of UIDs that appear in 2003.

      In the second row (2004), third column (2005), marked by an X, I want the number of UIDs that appear in 2004, but also appear in 2005.

      Is this possible in Tableau?

       

      Thank you in advance,

      Bill.