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