Data Studio
2.3K members online now
2.3K 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