When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with Google Analytics.
Metrics
Google Analytics Data Type |
Spotfire Data Type |
CURRENCY |
Currency |
INTEGER |
LongInteger |
FLOAT |
Real |
PERCENT |
Real |
TIME |
TimeSpan |
Dimensions
Google Analytics Data Type |
Spotfire Data Type |
STRING In most cases. |
String
|
STRING If the dimension is any of the following:
|
Integer |
STRING If the dimension is Date. |
Date
|
STRING If the dimension is Longitude or Latitude. |
Real
|