{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/3111","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/3111/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/3111/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/3111/events","html_url":"https://github.com/influxdb/influxdb/issues/3111","id":90470925,"number":3111,"title":"Arithmetic operators not working on Count() results in a join","user":{"login":"Baddja","id":1211388,"avatar_url":"https://avatars.githubusercontent.com/u/1211388?v=3","gravatar_id":"","url":"https://api.github.com/users/Baddja","html_url":"https://github.com/Baddja","followers_url":"https://api.github.com/users/Baddja/followers","following_url":"https://api.github.com/users/Baddja/following{/other_user}","gists_url":"https://api.github.com/users/Baddja/gists{/gist_id}","starred_url":"https://api.github.com/users/Baddja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Baddja/subscriptions","organizations_url":"https://api.github.com/users/Baddja/orgs","repos_url":"https://api.github.com/users/Baddja/repos","events_url":"https://api.github.com/users/Baddja/events{/privacy}","received_events_url":"https://api.github.com/users/Baddja/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-06-23T19:28:49Z","updated_at":"2015-06-24T21:30:05Z","closed_at":null,"body":"```\r\nselect count(Listing.id) / count(Message.id) from Listing inner join Message\r\n```\r\n\r\nresults in `Value cannot be evaluated for type &{count 10 [0xc208323270] <nil> false}`\r\n\r\nWhat I want is the ratio of listings to messages over a given time. I am using grafana in raw query mode.\r\nThis is the full query:\r\n```\r\nselect count(Listing.id) / count(Message.id) from Listing inner join Message where $timeFilter group by time($interval) order asc\r\n```"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/115018007","html_url":"https://github.com/influxdb/influxdb/issues/3111#issuecomment-115018007","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/3111","id":115018007,"user":{"login":"beckettsean","id":6537329,"avatar_url":"https://avatars.githubusercontent.com/u/6537329?v=3","gravatar_id":"","url":"https://api.github.com/users/beckettsean","html_url":"https://github.com/beckettsean","followers_url":"https://api.github.com/users/beckettsean/followers","following_url":"https://api.github.com/users/beckettsean/following{/other_user}","gists_url":"https://api.github.com/users/beckettsean/gists{/gist_id}","starred_url":"https://api.github.com/users/beckettsean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beckettsean/subscriptions","organizations_url":"https://api.github.com/users/beckettsean/orgs","repos_url":"https://api.github.com/users/beckettsean/repos","events_url":"https://api.github.com/users/beckettsean/events{/privacy}","received_events_url":"https://api.github.com/users/beckettsean/received_events","type":"User","site_admin":false},"created_at":"2015-06-24T21:30:05Z","updated_at":"2015-06-24T21:30:05Z","body":"@chrischang7312 I don't know the 0.8.x query syntax very well, but this page should have the details: https://influxdb.com/docs/v0.8/api/query_language.html, particularly the \"Joining Series\" section at the bottom."}}