1 Reply Latest reply on Jun 21, 2018 4:28 AM by Yuriy Fal

    Rownumber and partition by in Tableau

    Krunal Maniar

      I am having a Kylin table as a data source in Tableau, i now want to create one calculated column in tableau which contains Row_Number.

      I am haivng one email adddress column which can have duplicate value.

       

      I want to partition by Email address column and order by timestamp descending, and then only want to query a data with Rownumber = 1, i.e. only unique email address records.

       

      How can i do this in Tableau.