{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/7738","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/7738/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/7738/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/7738/events","html_url":"https://github.com/influxdata/influxdb/issues/7738","id":196218938,"number":7738,"title":"Derivative emits timestamp with END of GROUP BY period instead of START of GROUP BY period","user":{"login":"ot3","id":10533325,"avatar_url":"https://avatars.githubusercontent.com/u/10533325?v=3","gravatar_id":"","url":"https://api.github.com/users/ot3","html_url":"https://github.com/ot3","followers_url":"https://api.github.com/users/ot3/followers","following_url":"https://api.github.com/users/ot3/following{/other_user}","gists_url":"https://api.github.com/users/ot3/gists{/gist_id}","starred_url":"https://api.github.com/users/ot3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ot3/subscriptions","organizations_url":"https://api.github.com/users/ot3/orgs","repos_url":"https://api.github.com/users/ot3/repos","events_url":"https://api.github.com/users/ot3/events{/privacy}","received_events_url":"https://api.github.com/users/ot3/received_events","type":"User","site_admin":false},"labels":[{"id":203460192,"url":"https://api.github.com/repos/influxdata/influxdb/labels/area/functions","name":"area/functions","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-17T12:09:12Z","updated_at":"2016-12-19T12:20:14Z","closed_at":null,"body":"Consider the following query:\r\n\r\n```\r\nSELECT derivative(mean(\"value\"), 1h) FROM \"gas_meter\" WHERE time>1481673600000000 GROUP BY time(1h) fill(none)\r\n\r\n2016-12-14T07:00:00Z 0.028999999999996362\r\n2016-12-14T08:00:00Z 0.6169999999997344\r\n2016-12-14T09:00:00Z 0.9340000000001965\r\n2016-12-14T10:00:00Z 0.9279999999998836\r\n2016-12-14T11:00:00Z 0.849999999999909\r\n2016-12-14T12:00:00Z 0.7699999999999818\r\n```\r\n\r\nThe value of \"0.6169999999997344\" has a timestamp of 08:00 UTC which is at the END of the period for which this value is true. This means that when I use a presentation program such as Grafana, it renders the value of \"0.6169999999997344\" from 08:00-09:00 UTC which is incorrect and undesirable as this value is only valid between 07:00 and 08:00. \r\n\r\nI have not found any solution to avoid this 1hr. offset. If such a solution exists, I'd like to know, if not I'll submit a feature request.\r\n\r\nIs there a solution or even a workaround?\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/267951472","html_url":"https://github.com/influxdata/influxdb/issues/7738#issuecomment-267951472","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/7738","id":267951472,"user":{"login":"e-dard","id":501993,"avatar_url":"https://avatars.githubusercontent.com/u/501993?v=3","gravatar_id":"","url":"https://api.github.com/users/e-dard","html_url":"https://github.com/e-dard","followers_url":"https://api.github.com/users/e-dard/followers","following_url":"https://api.github.com/users/e-dard/following{/other_user}","gists_url":"https://api.github.com/users/e-dard/gists{/gist_id}","starred_url":"https://api.github.com/users/e-dard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/e-dard/subscriptions","organizations_url":"https://api.github.com/users/e-dard/orgs","repos_url":"https://api.github.com/users/e-dard/repos","events_url":"https://api.github.com/users/e-dard/events{/privacy}","received_events_url":"https://api.github.com/users/e-dard/received_events","type":"User","site_admin":false},"created_at":"2016-12-19T12:20:14Z","updated_at":"2016-12-19T12:20:14Z","body":"@jsternberg any idea on this?"}}
{"actor":{"display_login":"e-dard"}}