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

Using Google Sheet as data source - how to import multiple number types?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello, I'm new to Google Data Studio. Trying to import two numerical types from a single Sheet (number and a computed percentage)

Source:

Screen Shot 2017-07-19 at 5.43.49 PM.png

 

Here's how it is set up in Data Studio:

Screen Shot 2017-07-19 at 5.44.27 PM.png

 

And how it displays as a Table widget:

Screen Shot 2017-07-19 at 5.44.03 PM.png

 

Is there a way to have Data Studio support multiple numeric types - or bring in the same values on the source sheet? Have tried changing Amount to just text, but it still won't display the percent figure correctly.

 

Thanks in advance for any suggestions you can provide!

 

pjk

Using Google Sheet as data source - how to import multiple number types?

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

One column equals one numeric type. I would suggest you to create other columns with the right numeric format.