Retrieve data from influxdb in higher precision

General
1

Hello kind souls, I need some help working on my first project with influxdb and grafana here. I need to retrieve my past data from influxdb with the highest precision I can. I have successfully retrieved my data through using query I get from grafana, which is shown on the influxdb node in the figure.

image
image1644×134 45.4 KB

However, I can only get my data using "GROUP BY" and "fill(null)" because sometimes my sensors gives null value. The highest precision I can get is 1second by using "GROUP BY", I couldn't get my data that is between every 1 second interval.
Anyone know how else I should write my query to get my data from influxdb in the highest precision of my data?

2

If you want to get all the samples that are in the database then remove the group by completely and select just the value rather than the mean.

3

You might want to read the influx documentation for durations https://docs.influxdata.com/influxdb/v1.8/query_language/spec/#durations

4

Thank you for your reply! I will try again with your suggestions!

5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.