Hi Christian, It's not exactly clear from your description how you want this stacking. It would probably be best if you could draw a sample image. But I can say a couple things about the constraints in Google Charts currently.
In the classic charts, if you specify isStacked, then all the series will be stacked in one stack per x value. Stacks can grow both positively and negatively, so you almost get the effect of having two stacks. This might correspond to your "out" and "in" directions. It sounds like you want multiple stacks for each x value, however. So for each x value, there would be more than one stack, drawn side by side. The classic charts don't support that, but the new Material charts do. For the Material 'bar' chart, see https://devsite.googleplex.com/chart/interactive/docs/gallery/columnchart#creating-material-column-charts Hope that helps. On Mon, Jun 22, 2015 at 2:07 PM, Christian Alexander <[email protected]> wrote: > Hi Everyone, > > I'm currently pulling Rows in the following format : Name, Direction, > Date, Messages, Alerts. > > I would like to make a stacked column chart by using the data as the > X-Axis and stacking the sums of option A and B according to Organization. > In this case, for each date on the X-Axis, I'd like there to be two columns > (out and in direction), containing the grouped sum of messages and alerts > for that day in the "out" or "in" direction. > > As of right now, I've gotten only to grouping by date, but not by grouping > the organizations. I've been attempting to group the data first by > direction and then by date, but I'm not sure how to add the date column to > the direction grouping. > > I was wondering if anyone could guide me in the right direction on how to > accomplish this. I did a slight bit of digging and couldn't find anything > related, so apologies if this has already been answered. > > Thanks, > > Christian > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
