Metric data type can not be changed back to it's original data type.

[ph5ive]

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.

1. ... Using GDS create a connection to InfluxData Cloud2 service, setting the InfluxDB URL, Token, Organisation, Bucket and Measurement.
2. ... Within GDS, at the field editing section, change the 'time' metric data type from 'Date & Time' to data type 'Text'.
3. ... 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

[bednar]

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:

• https://support.google.com/datastudio/answer/7512288

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
• https://github.com/influxdata/influxdb-gds-connector/blob/c035907cd9bfff498ce39544968c65e5dc03991d/src/InfluxDBClient.js#L202

Regards

[bednar]

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.