newbie with crossfilter (in javascript, more precisely) here.
I have a database with the same idea as below and I want to plot a composite graph in dc.js + crossfilter.js with one line for each axis. In this case, I'll show only one sensor at a time. Note that for each sensor, the values for the axis share the same seconds.
I'm creating a dimension with the 'seconds' and I want to create a group for each 'axis' but I need to filter the values of 'seconds' based on the 'axis'. For instance, to create the line in the chart for axis 'x', I need to use the dimension 'seconds' and a group with 'value', but only those from the axis x.
seconds ; sensor ; axis ; value
1 ; head ; x ; 10
2 ; head ; x ; 9
3 ; head ; x ; 7
1 ; head ; y ; 11
2 ; head ; y ; 5
3 ; head ; y ; 4
1 ; waist ; x ; 11
2 ; waist ; x ; 5
3 ; waist ; x ; 4
I tried some options, but no success so far.
Any ideas?