3 Replies Latest reply on Apr 4, 2018 4:43 PM by James Rowntree

    Concatenating?! string + aggregate

    Benjamin Cole

      Hello Ya'll,

       

      I'm sure this question has been answered many times online already, but I wasn't able to find it yet.

       

      Sooo, I have.....

      Author Name - String of names

      Titles - String of titles

       

      I want to create a calculated field that is Author Name + the countD (Title)

       

      Calculated Field

      [Author Name] + STR(COUNTD([Title]))

       

      RESULT

      Name             (count of titles)

      Maggie Nelson (6)

      Cornel West (4)

       

      .... you get the idea

       

      But  ----> cannot mix aggregate and non-aggregate tableau!

       

      Whats next?? CASE statement? IF statement?

       

      Thanks!

      Ben