Metrics and Dimensions are imported around the wrong way
Closed this issue · 7 comments
Currently when data is imported into data studio from InfluxDB, time is imported as a metric (blue) while the metrics are imported as dimensions (green). This should be the opposite way round and currently makes this unusable.
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
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
You are able to change how you visualise your data. Just change dimension to time and as a metric add Average of temperature_C.
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.
Hi Bednar,
I was able to set time as a metric through the custom field.
Thanks for your help.
You could use TODATE function:
Works for me
Formula for new calculated time dimension
TODATE(time, '%Y-%m-%d %H:%M:%S', '%Y%m%d%H%M')
