# Retrieve data from influxdb in higher precision

**URL:** <https://discourse.nodered.org/t/retrieve-data-from-influxdb-in-higher-precision/27024>\
**Category:** General\
**Created:** [21 May 2020 09:12 UTC](https://discourse.nodered.org/t/retrieve-data-from-influxdb-in-higher-precision/27024 "2020-05-21T09:12:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JPUA](https://avatars.discourse-cdn.com/v4/letter/j/b5a626/32.png) [@JPUA](https://discourse.nodered.org/u/JPUA)\
**Post date:** [21 May 2020 09:12 UTC](https://discourse.nodered.org/t/retrieve-data-from-influxdb-in-higher-precision/27024/1 "2020-05-21T09:12:35Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/0/a0946dccb1003861c479b3df60bc0e2ebc011dc2.png)  
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?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [21 May 2020 12:31 UTC](https://discourse.nodered.org/t/retrieve-data-from-influxdb-in-higher-precision/27024/2 "2020-05-21T12:31:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [21 May 2020 12:34 UTC](https://discourse.nodered.org/t/retrieve-data-from-influxdb-in-higher-precision/27024/3 "2020-05-21T12:34:01Z")

</div>

You might want to read the influx documentation for durations [https://docs.influxdata.com/influxdb/v1.8/query\_language/spec/#durations](https://docs.influxdata.com/influxdb/v1.8/query_language/spec/#durations)

---

<div class="post-metadata">

**Author:** ![JPUA](https://avatars.discourse-cdn.com/v4/letter/j/b5a626/32.png) [@JPUA](https://discourse.nodered.org/u/JPUA)\
**Post date:** [21 May 2020 13:53 UTC](https://discourse.nodered.org/t/retrieve-data-from-influxdb-in-higher-precision/27024/4 "2020-05-21T13:53:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [20 July 2020 13:53 UTC](https://discourse.nodered.org/t/retrieve-data-from-influxdb-in-higher-precision/27024/5 "2020-07-20T13:53:57Z")

</div>

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