Getting total of user names in 3 different fields - using COUNT returns incorrect totals[ Edited ]
May 2017 - last edited May 2017
I am new to DataStudio and am attempting to get a total for a user name that may appear in 3 different fields.
Here is my metric:
COUNT(seassigned) + COUNT(seassigned1) + COUNT(seassigned2)
If I have the name John Doe in all 3 fields, I would hope to see a total of 3 for John Doe in a pie chart for example. However, I am getting random numbers in the pie chart.
The 3 fields hold a String value and the values are selected from a list, so they are matching names.
Is there another way to do this?