Metrics and Dimensions are imported around the wrong way about influxdb-gds-connector HOT 7 CLOSED

Works for me

Formula for new calculated time dimension
TODATE(time, '%Y-%m-%d %H:%M:%S', '%Y%m%d%H%M')

from influxdb-gds-connector.

Hi @BeenFifteen,

thanks for using our connector.

I think that the mapping highly depend on your InfluxDB schema. The connector is not able to know how was your field aggregated.

The metrics could be use as a source for aggregated operation:

Schema:

Aggregated function over metrics:

For more info see our example: https://github.com/influxdata/influxdb-gds-connector/tree/master/examples

If this setting doesn't fit your requirements, Could you please share a little bit more info about your InfluxDB schema and how you want to use it in Google Data Studio?

Regards

from influxdb-gds-connector.

Hi bednar,

Thanks for the quick reply and for everything you've done on this connector.

Currently I am simply trying to begin with a basic weather station dashboard using my weather station information stored on influxdb.
The first thing I wanted to implement was a time-series chart so I tried to set it up as follows.

But as can be seen above it couldn't be done.
Other time-series charts get set-up as seen in the example following with time being the dimension, and the other fields being metrics.

Is this an issue with my InfluxDB field setup or with the connector?

Thanks

from influxdb-gds-connector.

You are able to change how you visualise your data. Just change dimension to time and as a metric add Average of temperature_C.

from influxdb-gds-connector.

I was able to shift a dimension to be a metric as you recommended. But the metric of time doesn't appear to be able to be set as a dimension even when setting it up time as a custom field.

from influxdb-gds-connector.

Hi Bednar,

I was able to set time as a metric through the custom field.

Thanks for your help.

from influxdb-gds-connector.

You could use TODATE function:

from influxdb-gds-connector.