Metric data type can not be changed back to it's original data type.
ph5ive opened this issue · 2 comments
The issue:
I noticed that if you change the metrics data type from 'Date & Time' to 'Text' you can't change it back.
This is because the 'Date & Time' option is no longer available in the LOVs.
Steps to reproduce:
List the minimal actions needed to reproduce the behavior.
- ... Using GDS create a connection to InfluxData Cloud2 service, setting the InfluxDB URL, Token, Organisation, Bucket and Measurement.
- ... Within GDS, at the field editing section, change the 'time' metric data type from 'Date & Time' to data type 'Text'.
- ... Now, try to change it back from 'Text' to a 'Date & Time'.
Expected behavior:
You should be able to change the data type back using the LOVs.
Actual behavior:
The original data type of 'Date & Time' is no longer available in the LOVs.
Specifications:
- Client Version: 2021.10
- InfluxDB Version: 2.x Cloud
- Platform: n/a
Hi @ph5ive,
thanks for using our connector.
The values available in LOVs are controlled by GDS. According to the following docs, the column with AUTO aggregation cannot be change:
I have to investigate how we define the time
metrics and if we need to change something here:
- https://developers.google.com/datastudio/connector/reference#field
influxdb-gds-connector/src/InfluxDBClient.js
Line 202 in c035907
Regards
We have to set the defaultAggregationType
config for the time
to false
. After that the time
will be dimension
(green) type and the LOVs will contains full range of types.
- https://support.google.com/datastudio/answer/6402048?ref_topic=7441655#zippy=%2Cin-this-article
- https://support.google.com/datastudio/thread/18307022
- https://stackoverflow.com/a/66858872
The "blue" is supposed to use for fields with pre-aggregated values.