Comments (7)
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:
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.
Related Issues (16)
- Compatibility with InfluxDB 1.8.x
- no buckets found in organization HOT 5
- InfluxDB Connector Issue HOT 2
- Error on measurments with a tag with different values HOT 4
- GDS Connector not found HOT 2
- Error when trying to add the connector HOT 1
- Publish connector as a Partner connector HOT 12
- Metric data type can not be changed back to it's original data type. HOT 2
- InfluxDB Connector Issue HOT 1
- Not an issue HOT 3
- Datasource cannot retrieve list of Buckets HOT 1
- InfluxDB Connector Issue HOT 1
- InfluxDB Beta is changing default port from 9999 to 8086 for the next release
- Improve error message
- InfluxDB Connector Issue HOT 34
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from influxdb-gds-connector.