{"action":"closed","issue":{"url":"https://api.github.com/repos/grafana/grafana/issues/2735","labels_url":"https://api.github.com/repos/grafana/grafana/issues/2735/labels{/name}","comments_url":"https://api.github.com/repos/grafana/grafana/issues/2735/comments","events_url":"https://api.github.com/repos/grafana/grafana/issues/2735/events","html_url":"https://github.com/grafana/grafana/issues/2735","id":106287185,"number":2735,"title":"Assistance with graphing sparse points in Grafana?","user":{"login":"victorhooi","id":243499,"avatar_url":"https://avatars.githubusercontent.com/u/243499?v=3","gravatar_id":"","url":"https://api.github.com/users/victorhooi","html_url":"https://github.com/victorhooi","followers_url":"https://api.github.com/users/victorhooi/followers","following_url":"https://api.github.com/users/victorhooi/following{/other_user}","gists_url":"https://api.github.com/users/victorhooi/gists{/gist_id}","starred_url":"https://api.github.com/users/victorhooi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/victorhooi/subscriptions","organizations_url":"https://api.github.com/users/victorhooi/orgs","repos_url":"https://api.github.com/users/victorhooi/repos","events_url":"https://api.github.com/users/victorhooi/events{/privacy}","received_events_url":"https://api.github.com/users/victorhooi/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-09-14T07:39:51Z","updated_at":"2015-09-14T08:28:00Z","closed_at":"2015-09-14T08:28:00Z","body":"I am attempting to graph how long database operations take in Grafana/InfluxDB.\r\n\r\nThe duration is stored in a field named `duration_in_miliseconds`.\r\n\r\nThese points do not occur regularly - rather, there is a point for each database operation.\r\n\r\nIf I try to graph the points directly in Grafana using say, mean, I get a flat line around zero:\r\n\r\n![screenshot 2015-09-14 17 33 13](https://cloud.githubusercontent.com/assets/243499/9844438/b3018186-5b06-11e5-9c2c-1e46d71df2b5.png)\r\n\r\nThe query that is being sent to InfluxDB looks like this:\r\n\r\n```\r\nSELECT mean(\"duration_in_milliseconds\") AS \"duration_in_milliseconds\" FROM \"operations\" WHERE \"project\" = 'test' AND time > 1439750000s and time < 1439751267s GROUP BY time(100ms)\r\n```\r\n\r\nIf I run that from the InfluxDB shell, I do get a bunch of empty times with no values - I'm guessing this is due to the GROUP BY clause, correct?\r\n```\r\n> SELECT mean(\"duration_in_milliseconds\") AS \"duration_in_milliseconds\" FROM \"operations\" WHERE \"project\" = 'test' AND time > 1439750000s and time < 1439751267s GROUP BY time(100ms) LIMIT 100\r\nname: operations\r\n----------------\r\ntime                    duration_in_milliseconds\r\n2015-08-16T18:33:20Z\r\n2015-08-16T18:33:20.1Z\r\n2015-08-16T18:33:20.2Z\r\n2015-08-16T18:33:20.3Z\r\n2015-08-16T18:33:20.4Z\r\n2015-08-16T18:33:20.5Z\r\n2015-08-16T18:33:20.6Z\r\n2015-08-16T18:33:20.7Z\r\n2015-08-16T18:33:20.8Z\r\n2015-08-16T18:33:20.9Z\r\n2015-08-16T18:33:21Z\r\n2015-08-16T18:33:21.1Z\r\n2015-08-16T18:33:21.2Z\r\n2015-08-16T18:33:21.3Z\r\n2015-08-16T18:33:21.4Z\r\n2015-08-16T18:33:21.5Z\r\n2015-08-16T18:33:21.6Z\r\n2015-08-16T18:33:21.7Z\r\n2015-08-16T18:33:21.8Z\r\n```\r\n\r\nIf I query without any aggregations, I can see the values I put in:\r\n\r\n```\r\n> SELECT duration_in_milliseconds FROM \"operations\" WHERE \"project\" = 'test' AND time > 1439750000s and time < 1439751267s\r\nname: operations\r\n----------------\r\ntime                            duration_in_milliseconds\r\n2015-08-16T18:33:40.244Z        1723\r\n2015-08-16T18:34:38.395000064Z  2231\r\n2015-08-16T18:36:37.286000128Z  1164\r\n2015-08-16T18:36:37.286000128Z  1144\r\n2015-08-16T18:36:37.286000128Z  1211\r\n2015-08-16T18:36:37.287000064Z  1230\r\n2015-08-16T18:36:37.287000064Z  1269\r\n2015-08-16T18:36:37.287000064Z  1186\r\n2015-08-16T18:36:37.287000064Z  1288\r\n2015-08-16T18:36:37.287000064Z  1159\r\n2015-08-16T18:36:37.287000064Z  1228\r\n2015-08-16T18:36:37.288Z        1230\r\n2015-08-16T18:36:37.288Z        1161\r\n2015-08-16T18:36:37.288Z        1174\r\n2015-08-16T18:36:37.288Z        1327\r\n2015-08-16T18:36:37.288Z        1477\r\n2015-08-16T18:36:37.288Z        1304\r\n2015-08-16T18:36:37.288Z        1231\r\n2015-08-16T18:36:37.288Z        1152\r\n2015-08-16T18:36:37.288Z        1494\r\n2015-08-16T18:36:37.288999936Z  1232\r\n2015-08-16T18:36:37.288999936Z  1187\r\n2015-08-16T18:36:37.288999936Z  1183\r\n2015-08-16T18:36:37.288999936Z  1104\r\n```\r\n\r\nMy question is, is there a way to graph this in Grafana, without resorting to plotting the raw points? (I don't want to swamp the browser with millions of points).\r\n\r\nI tried playing with the fill field under Group By, but none of those options had any effect."}}