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

Concatenating?! string + aggregate

Benjamin Cole Apr 4, 2018 3:59 PM

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

1. Re: Concatenating?! string + aggregate

Wesley Magee Apr 4, 2018 4:05 PM (in response to Benjamin Cole)

Benjamin,
Have you tried wrapping the [Author Name] in an attribute function?

ATTR([Author Name])

-Wesley
Like Show 1 Likes(1)

Actions
2. Re: Concatenating?! string + aggregate

Deepak Rai Apr 4, 2018 4:33 PM (in response to Benjamin Cole)

you can use any one out of MIN,MAX, ATTR with Author Name

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

Similarly for MAX and ATTR
Like Show 1 Likes(1)

Actions
3. Re: Concatenating?! string + aggregate

James Rowntree Apr 4, 2018 4:43 PM (in response to Benjamin Cole)
Hi Benjamin,

Have a look at this thread: Concatenate count of date (integer) and a string?

Basically, Anna Cheetham suggested using FIXED to force the issue. Something like this...

[Author Name] + ' ' + str({ FIXED [Author Name] : countd([Title])})

It worked in the attached (very simple) example on superstore in 10.5.2

concat aggreate and string.twbx 1.2 MB
Like Show 0 Likes(0)

Actions

Tableau Community