Regroup data on the fly

[Michelle Stewart]

I've created the following jsfiddle demonstrating my issue

My problem is that I have data coming in as an array of json objects which need to stay in that format due to it's multi-purpose nature.

One of the things I would like to let my users do is to see their data grouped by something other than date (the first column) as they may have several columns their data pertains to.

I am very greatful to asgallant who helped me get my code as far as it is.

The example filters and groups as desired, unless filters and groups are used together.  The filters will stay applied with the group if I do that first, but as soon as I change a filter, the columns go back to the default of date.

How can I make these two communicate?  I know I have two dataTables of information which is probably part of my problem, but I am not understanding their relationship quite well enough to fix this.

Thanks in advance,

Michelle

[asgallant]

In the junk chart's 'ready' event handler, you need to change one piece of one line:

var group = google.visualization.data.group(tempData, [0], graphArr);

change the 0 to the value of the group selection, eg:

var group = google.visualization.data.group(tempData, [parseInt($("#chartGroup").val())], graphArr);

as the 0 is what forces the charts back to using the Date column as their x-axis.  See the fix here: http://jsfiddle.net/asgallant/8aQ6u/15/

[Michelle Stewart]

AWESOME!!! THANK YOU SOOOO MUCH for the Speedy reply!  I should have caught that but for some reason didn't think it was getting re-fired (should've checked!)

Thanks again!