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

DataStudio COUNT Function + Displaying on Bar Graph

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

I understand that DataStudio has a 'COUNT' function, which I have used before.

 

I have a spreadsheet with a column of numbers, ranging from 0 to 10.

 

What I'd like to do is:

Count how many times a number between:

0 - 2 occurs

3 - 4 occurs

5 - 6 occurs

7 - 8 occurs

8+ occurs

 

Once that's done, I'd like to display the counts all on the same bar graph (comparing against each other).

I have all the numbers in one column...but I can't figure out how to do this.

 

Can someone please help?

 

I understand if they were dates, I may be able to use DATE_DIFF, but they're not. They're just numbers to two decimal places (ex. 2.71).


Thanks!