google data studio converting silently data types?

72 Views Asked by At

I am consuming some external data from postgres (using google data studio):

enter image description here

The column is 'costperhour', why the data type appears as 'hour'? I think is a mistake...

i.e.

enter image description here

could it be that it just converted automatically 15, 10, 12, 8 and 10 to those values?

1

There are 1 best solutions below

0
On BEST ANSWER

At the Data Source, it can be achieved by changing the Type of the costperhour field to the required Type, for example:

From:

Date > Hour

To:

Currency > USD - US Dollar ($) 

Google Data Studio Report and a GIF to demonstrate