{"action":"reopened","issue":{"url":"https://api.github.com/repos/GeoNet/fits/issues/68","repository_url":"https://api.github.com/repos/GeoNet/fits","labels_url":"https://api.github.com/repos/GeoNet/fits/issues/68/labels{/name}","comments_url":"https://api.github.com/repos/GeoNet/fits/issues/68/comments","events_url":"https://api.github.com/repos/GeoNet/fits/issues/68/events","html_url":"https://github.com/GeoNet/fits/issues/68","id":142819906,"number":68,"title":"enable a query to calculate an average value for fixed, non-overlapping time intervals","user":{"login":"rumachan","id":10933207,"avatar_url":"https://avatars.githubusercontent.com/u/10933207?v=3","gravatar_id":"","url":"https://api.github.com/users/rumachan","html_url":"https://github.com/rumachan","followers_url":"https://api.github.com/users/rumachan/followers","following_url":"https://api.github.com/users/rumachan/following{/other_user}","gists_url":"https://api.github.com/users/rumachan/gists{/gist_id}","starred_url":"https://api.github.com/users/rumachan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rumachan/subscriptions","organizations_url":"https://api.github.com/users/rumachan/orgs","repos_url":"https://api.github.com/users/rumachan/repos","events_url":"https://api.github.com/users/rumachan/events{/privacy}","received_events_url":"https://api.github.com/users/rumachan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"gclitheroe","id":1016463,"avatar_url":"https://avatars.githubusercontent.com/u/1016463?v=3","gravatar_id":"","url":"https://api.github.com/users/gclitheroe","html_url":"https://github.com/gclitheroe","followers_url":"https://api.github.com/users/gclitheroe/followers","following_url":"https://api.github.com/users/gclitheroe/following{/other_user}","gists_url":"https://api.github.com/users/gclitheroe/gists{/gist_id}","starred_url":"https://api.github.com/users/gclitheroe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gclitheroe/subscriptions","organizations_url":"https://api.github.com/users/gclitheroe/orgs","repos_url":"https://api.github.com/users/gclitheroe/repos","events_url":"https://api.github.com/users/gclitheroe/events{/privacy}","received_events_url":"https://api.github.com/users/gclitheroe/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-03-23T00:32:22Z","updated_at":"2016-03-29T22:48:44Z","closed_at":null,"body":"Can we query and calculate an average (mean) over a fixed time interval as part of the query? For example, if we have data sampled at an interval of one hour or at irregular intervals smaller than one day, can we query those data a get daily averages returned (and plotted), instead of the original data? I'm thinking of something like avg=d as part of the query url.\r\n\r\nFor volcanic flux data,we will implement the fluxes from individual scans, so that we have the potential to look at how flux changes over short time intervals. But for longer time periods a daily average value will still be required. If that can be done, it would also be nice to be able to query avg=m or avg=y (for month or year). Is &avg=10d (10 day average) possible? For these I am referring to a fixed window length with no overlap. So if  we queried with avg=m, the dates would be the first of each month, and the averaged values would be all those in that month.\r\n\r\nCan these queries return the standard deviation or the standard error of the values in the 'error' column?\r\n\r\nAre some other query modifiers of a similar type possible? For example, count in the window, minimum value, maximum value"}}