AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Getting total of user names in 3 different fields - using COUNT returns incorrect totals

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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?

 

Thanks!
Dan

Getting total of user names in 3 different fields - using COUNT returns incorrect totals

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

@Dan Z

Can you show us your pie chart and the configuration of your chart ?  

Getting total of user names in 3 different fields - using COUNT returns incorrect totals

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

How do I paste images in here or do I need to link them from an URL?

 

I don't want to share the report itself due to confidential info...

 

Thanks!
Dan

Getting total of user names in 3 different fields - using COUNT returns incorrect totals

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

Dan, under buttons "cancel" "post", click on "full reply editor"

You can add photo and more others things

Re: Getting total of user names in 3 different fields - using COUNT returns incorrect totals

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

datastudio_pie_chart.pngdatastudio_pie_chart_prop.pngdatastudio_calc_field.png