javascript - Grouping Data with Flot Charts -


scenario: i'm plotting volume bar chart using flot js, per-minute data. example, 3 hours, have 3 x 60 data points being pulled database.

problem: since there have 6 hours worth of data points, , width of chart 250px, bars 1px wide each, without margins. wondering if there's grouping data option in flot charts tell average volume data per 15 minutes or 30 minutes.

$.plot('#flot-vol, [{     color: '#fff',     bars: { show: true },     data: datav }], {     grid: { show: false },     shadowsize: false });

in high charts there groupdata option wherein can group given data day / week / months. wondering if there's such feature in flot charts?

if need use mysql group data, how group data per 30 minutes if have following mysql statement? i'm pulling volume of latest date table named ticker.

select unix_timestamp(`timestamp`), `volume` `ticker` compid = 'symbol' , date(`timestamp`) = (select max(date(`timestamp`)) `ticker`)

update:

thanks ryley clarifying answer, in case wondering how group data through mysql, here is. mysql statement worked

select unix_timestamp(`timestamp`), avg(`volume`) `ticker` `compid` = 'symbol' , date(`timestamp`) = (select max(date(`timestamp`)) `ticker`) group (unix_timestamp(`timestamp`) div 30*60)

flot not aggregate data itself, you're on right track thinking doing mysql.

make query average data 30 minute segments:

select trunc(unix_timestamp(`timestamp`)/(30*60))*(30*60) time_chunk,         avg(`volume`) `ticker`  compid = 'symbol' ,        date(`timestamp`) = (select max(date(`timestamp`)) `ticker`) group time_chunk

i'm not mysql user, may not right, idea take timestamp , truncate 30 minute increments, average volume on 30 minutes.


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more