Numbers not detected in Google Data Studio

user_14465912 0
Viewed 1449

I tried to create a Dashboard to represent COVID-19 data set which is available at https://www.worldometers.info/coronavirus/

During that process I created a Pie Chart with New Cases (COVID-19) and the highest value shown is 602, which is not the case (highest value should be 10,192 as of now).

Please refer the image of the Dashboard and the Data Set.

Hint: 602 is the highest value which is less than 1000 and in the worldometer website numbers are formatted with thousand separator. I can not find a solution but I think this is something to do with that thousand separator.

This is the Dashboard - Please refer the table & pie chart (left):

1

This is my Data Set - Please look for New Cases Column:

2

This is my Data Source - New Cases Field is with Number Data Type:

3

google-data-studio google-sheets
1 Answers

The New Cases field is currently recognised as a Text field in Google Sheets (Data Set), thus the comma in +10,192 is a literal comma; one way in the Data Set is to change the format from Plain Text to Number, alternatively, it could be achieved in Google Data Studio:

1) Type: Text

At the Data Source, set the Type of the New Cases field to Text.

2) GDS_New Cases

Create the REGEXP_REPLACE Calculated Field below and use the GDS_New Cases field instead of New Cases

CAST(REGEXP_REPLACE(New Cases, "[\\+,]","") AS NUMBER)

Google Data Studio Report and a GIF to elaborate:

user_128925530
Related