No recognizing cell format in google sheet as numeric

Looker Q&A Looker Studio
1

I have a pretty simple chart that is using a Google Sheet as the source. One of my columns is numeric, but LS sees it as text. I’ve tried to change the format in the data source, but then it returns a null value. I know for a fact that it isn’t null, it’s a pretty small dataset right now.

I’ve tried modifying the formatting in the Google Sheet and LS, but nothing changes.

Someone please help me!!!

2

Hey @jslayton

First, just a sanity checks:

  • Have you forced the format of the column in Google Sheets to Number? (selecting the column and choosing Number in the Format menu)
  • If you display in a table chart all the values of the column (so as a text), do you see empty strings or something special that could explain the bad recognition of the format?

Otherwise, not perfect but you ca create a calculated field casting the text to number:

CAST(my_number_recognized_as_text AS NUMBER)

I hope it helps.

Mehdi

3

Thank you for your response. Yes, I’ve tried numeric, currency,

I had some errors in cells because they were empty (formulas for future data) and I think that must have been throwing it off.

Thank you again though.

1 Like
4

Nice news. So there are explanations. The best things would be to adapt the Sheets formula to return 0 by default.

Feel free to tell me if you need more info, otherwise you can accept my first answer as a solution to close the topic.

Mehdi

5

I did and that’s how I got it working.

Thank you