Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Integral function does not work as expected #13968

Closed
hhaim opened this issue May 19, 2019 · 2 comments
Closed

Integral function does not work as expected #13968

hhaim opened this issue May 19, 2019 · 2 comments

Comments

@hhaim
Copy link

hhaim commented May 19, 2019

> precision rfc3339
> select value from "switch.b0" where time > now() - 2d
name: switch.b0
time                           value
----                           -----
2019-05-07T14:35:42.53137408Z  0
2019-05-07T14:37:37.760206848Z 0
2019-05-07T14:38:17.240751104Z 0
2019-05-07T14:39:57.58061184Z  0
2019-05-07T14:43:48.437899008Z 0
2019-05-07T14:44:28.117872896Z 0
2019-05-07T15:04:28.287107072Z 0
2019-05-07T15:06:55.139759104Z 0
2019-05-07T15:09:42.865874176Z 0
2019-05-08T15:05:04.114242048Z 1
2019-05-08T16:04:04.167064832Z 0
2019-05-08T16:21:04.190484992Z 1
2019-05-08T17:34:04.115187968Z 0
2019-05-09T09:02:43.806310912Z 0
2019-05-09T09:53:06.466994944Z 0

> select integral("value",1h) from "switch.b0" where  (time > now() - 2d)

time                 integral
----         
1970-01-01T00:00:00Z 13.202951293582222
>
>

While the expected value is ~2 hours

2019-05-08T15:05:04.114242048Z 1
2019-05-08T16:04:04.167064832Z 0
2019-05-08T16:21:04.190484992Z 1
2019-05-08T17:34:04.115187968Z 0
Connected to http://10.0.0.x:8086 version 1.7.6
InfluxDB shell version: 1.7.6
Enter an InfluxQL query
@russorat russorat added the 1.x label Aug 2, 2019
@stale
Copy link

stale bot commented Oct 31, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix label Oct 31, 2019
@stale
Copy link

stale bot commented Nov 7, 2019

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants