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]))



      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?