{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/3552","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/3552/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/3552/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/3552/events","html_url":"https://github.com/influxdata/influxdb/issues/3552","id":99038524,"number":3552,"title":"[feature request] Mathematics across measurements","user":{"login":"srfraser","id":5933384,"avatar_url":"https://avatars.githubusercontent.com/u/5933384?v=3","gravatar_id":"","url":"https://api.github.com/users/srfraser","html_url":"https://github.com/srfraser","followers_url":"https://api.github.com/users/srfraser/followers","following_url":"https://api.github.com/users/srfraser/following{/other_user}","gists_url":"https://api.github.com/users/srfraser/gists{/gist_id}","starred_url":"https://api.github.com/users/srfraser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srfraser/subscriptions","organizations_url":"https://api.github.com/users/srfraser/orgs","repos_url":"https://api.github.com/users/srfraser/repos","events_url":"https://api.github.com/users/srfraser/events{/privacy}","received_events_url":"https://api.github.com/users/srfraser/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/area/queries","name":"area/queries","color":"fbca04"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/area/query%20language","name":"area/query language","color":"fbca04"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/kind/feature%20request","name":"kind/feature request","color":"006b75"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/RFC","name":"RFC","color":"207de5"}],"state":"open","locked":false,"assignee":{"login":"corylanou","id":585100,"avatar_url":"https://avatars.githubusercontent.com/u/585100?v=3","gravatar_id":"","url":"https://api.github.com/users/corylanou","html_url":"https://github.com/corylanou","followers_url":"https://api.github.com/users/corylanou/followers","following_url":"https://api.github.com/users/corylanou/following{/other_user}","gists_url":"https://api.github.com/users/corylanou/gists{/gist_id}","starred_url":"https://api.github.com/users/corylanou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/corylanou/subscriptions","organizations_url":"https://api.github.com/users/corylanou/orgs","repos_url":"https://api.github.com/users/corylanou/repos","events_url":"https://api.github.com/users/corylanou/events{/privacy}","received_events_url":"https://api.github.com/users/corylanou/received_events","type":"User","site_admin":false},"assignees":[{"login":"corylanou","id":585100,"avatar_url":"https://avatars.githubusercontent.com/u/585100?v=3","gravatar_id":"","url":"https://api.github.com/users/corylanou","html_url":"https://github.com/corylanou","followers_url":"https://api.github.com/users/corylanou/followers","following_url":"https://api.github.com/users/corylanou/following{/other_user}","gists_url":"https://api.github.com/users/corylanou/gists{/gist_id}","starred_url":"https://api.github.com/users/corylanou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/corylanou/subscriptions","organizations_url":"https://api.github.com/users/corylanou/orgs","repos_url":"https://api.github.com/users/corylanou/repos","events_url":"https://api.github.com/users/corylanou/events{/privacy}","received_events_url":"https://api.github.com/users/corylanou/received_events","type":"User","site_admin":false},{"login":"jsternberg","id":1212129,"avatar_url":"https://avatars.githubusercontent.com/u/1212129?v=3","gravatar_id":"","url":"https://api.github.com/users/jsternberg","html_url":"https://github.com/jsternberg","followers_url":"https://api.github.com/users/jsternberg/followers","following_url":"https://api.github.com/users/jsternberg/following{/other_user}","gists_url":"https://api.github.com/users/jsternberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jsternberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsternberg/subscriptions","organizations_url":"https://api.github.com/users/jsternberg/orgs","repos_url":"https://api.github.com/users/jsternberg/repos","events_url":"https://api.github.com/users/jsternberg/events{/privacy}","received_events_url":"https://api.github.com/users/jsternberg/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/influxdata/influxdb/milestones/56","html_url":"https://github.com/influxdata/influxdb/milestones/1.1.0","labels_url":"https://api.github.com/repos/influxdata/influxdb/milestones/56/labels","id":1807337,"number":56,"title":"1.1.0","description":"Point release to come 2 months after 1.0","creator":{"login":"pauldix","id":4331,"avatar_url":"https://avatars.githubusercontent.com/u/4331?v=3","gravatar_id":"","url":"https://api.github.com/users/pauldix","html_url":"https://github.com/pauldix","followers_url":"https://api.github.com/users/pauldix/followers","following_url":"https://api.github.com/users/pauldix/following{/other_user}","gists_url":"https://api.github.com/users/pauldix/gists{/gist_id}","starred_url":"https://api.github.com/users/pauldix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pauldix/subscriptions","organizations_url":"https://api.github.com/users/pauldix/orgs","repos_url":"https://api.github.com/users/pauldix/repos","events_url":"https://api.github.com/users/pauldix/events{/privacy}","received_events_url":"https://api.github.com/users/pauldix/received_events","type":"User","site_admin":false},"open_issues":32,"closed_issues":39,"state":"open","created_at":"2016-06-03T14:53:39Z","updated_at":"2016-09-29T18:47:29Z","due_on":null,"closed_at":null},"comments":66,"created_at":"2015-08-04T19:02:14Z","updated_at":"2016-09-30T15:04:13Z","closed_at":null,"body":"\r\nApologies if this is a duplicate, I had a look and couldn't see a relevant issue. \r\n\r\nI can see from the documentation how to select from multiple measurements (although it calls them series, still, at https://influxdb.com/docs/v0.9/query_language/data_exploration.html )\r\n\r\nFor example, with data inserted by telegraf, you can do: \r\n`select * from disk_used,disk_total where host = 'myhostname' and path = '/'`\r\n\r\nHow would you express that as a percentage? I've tried variations of the following, and none seem to work:\r\n\r\n`select disk_used.value/disk_total.value from disk_used, disk_total where host = 'myhostname' and path='/'`\r\n\r\nThe \"mydb\".\"retentionpolicy\".\"measurement\" syntax doesn't work there, either. \r\n\r\nIs it a good idea to add aggregation functions for cases like `diff(value1, value2) from m1, m2`  and `divide(value, value) from m1, m2`, or should the arithmetic operators be working?\r\n\r\nAlso, I noticed when experimenting that it's also not possible to divide one derivative by another. For example, if I have two counters, bytes transferred and api calls made - both of which are constantly going up - how would you calculate the mean bytes per api call? "},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/250768374","html_url":"https://github.com/influxdata/influxdb/issues/3552#issuecomment-250768374","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/3552","id":250768374,"user":{"login":"rdworth","id":107824,"avatar_url":"https://avatars.githubusercontent.com/u/107824?v=3","gravatar_id":"","url":"https://api.github.com/users/rdworth","html_url":"https://github.com/rdworth","followers_url":"https://api.github.com/users/rdworth/followers","following_url":"https://api.github.com/users/rdworth/following{/other_user}","gists_url":"https://api.github.com/users/rdworth/gists{/gist_id}","starred_url":"https://api.github.com/users/rdworth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rdworth/subscriptions","organizations_url":"https://api.github.com/users/rdworth/orgs","repos_url":"https://api.github.com/users/rdworth/repos","events_url":"https://api.github.com/users/rdworth/events{/privacy}","received_events_url":"https://api.github.com/users/rdworth/received_events","type":"User","site_admin":false},"created_at":"2016-09-30T15:04:13Z","updated_at":"2016-09-30T15:04:13Z","body":"As another data point on use cases we have exactly the same use case as @kipe at [Flywheel Building Intelligence](https://github.com/flywheelbi)."}}
{"actor":{"display_login":"rdworth"}}