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
2.5K members online now
2.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How many times a text occurs in a document - count field data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello everyone,

I'm trying to produce a report with the number of how many times a certain field is present in a google sheet document,

but I had no luck in my attempts. Any hints? 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Roberto R
June 2017

How many times a text occurs in a document - count field data

Explorer ✭ ✭ ✭
# 8
Explorer ✭ ✭ ✭

Yeah, we're talking about the same thing. Read my previous reply. 

 

Using the COUNT option should do it. And if you want only the number of X value, then you could use a filter. 

View solution in original post

How many times a text occurs in a document - count field data

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

I'm guessing you already tried with Count and Count Distinct in your data source edit page within Data Studio? Otherwise, do you have further details on what you are trying to do? 

How many times a text occurs in a document - count field data

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hello Samuel, thanks for your answer.

Yes, I tried with COUNT but I did not really understand what it is meant for.

 

 

In the attempts I tried, for some reason, the Google Data COUNT response has a higher number than the real one.

I tried COUNT for a specific text, let's say "Rome" and the counter goes up to 1100, while counting it on google sheet with COUNT-IF formula reports a lower number (950)

How many times a text occurs in a document - count field data

Explorer ✭ ✭ ✭
# 4
Explorer ✭ ✭ ✭

With Count, Data Studio returns the number of values of X. If I got three "Rome" in my list, it will gives 3. If you use Count Distinct, it will return 1 for the same example. 

 

Read further infos here

 

Otherwise, I don't get why you would have to different number (one given by DS and the other by Sheets). Should be the same. 

 

How many times a text occurs in a document - count field data

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Samuel I think I have not been clear enough:

My colums is populated with different values. I need to COUNT how many times a value (it's text) occurs. Is there a formula ?

How many times a text occurs in a document - count field data

Explorer ✭ ✭ ✭
# 6
Explorer ✭ ✭ ✭

So you mean the number of values? 

How many times a text occurs in a document - count field data

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Yes, I mean the number of values.

 

Let's say I have this table:

 

       A            B

Roberto     Example

Roberto     Example

Example    Example

 

I need "as a result" the number of times "Roberto" occurs in column "A": 2

Marked as Best Answer.
Solution
Accepted by topic author Roberto R
June 2017

How many times a text occurs in a document - count field data

Explorer ✭ ✭ ✭
# 8
Explorer ✭ ✭ ✭

Yeah, we're talking about the same thing. Read my previous reply. 

 

Using the COUNT option should do it. And if you want only the number of X value, then you could use a filter. 

How many times a text occurs in a document - count field data

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭

It works.

I couldn't understand the mechanic. Thanks.

How many times a text occurs in a document - count field data

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

I have a similar issue but I don't know the name of the text values that are in the column...in my situation students will enter the book they read and I need to display the total number each book.  So I can't use countif because I can't anticipate all the books the students would read.  Any suggestions?