You can group your data using the google.visualization.data.group <https://google-developers.appspot.com/chart/interactive/docs/reference#google_visualization_data_group> function. Hook up an event handler on your dropdown that groups your data appropriately (you will want to use a modifier function on your date column to group by year, month, or day) and draws the chart using the grouped data.
Turning series on or off can be done a few different ways, here are a couple of examples I have made up: Show/hide columns by clicking on legend labels <http://jsfiddle.net/asgallant/6gz2Q/> and CategoryFilter as column selector <http://jsfiddle.net/asgallant/WaUu2/> On Wednesday, September 17, 2014 2:35:27 AM UTC-4, Shivani Kanakhara wrote: > > Hi , > I want to make a column chart where the data passed is something like this: > > Date Customer1 Customer2 > 12/2/2014 22.3 33.5 > 13/2/2014 34.6 33.0 > 12/3/2014 55.6 34.7 > 16/3/2014 70.8 56.7 > 2/05/2015 22.6 33.7 > 7/05/2015 36.7 44.7 > 13/8/2015 12.12 12.23 > 15/8/2015 13.7 44.5 > > > I have a dropdown containing values : 1) Year 2)Month and 3) Day > Now what i want is when i select Year the data should group by according > and haxis should contain labels having years 2014,2015 > When i select months the data should be grouped according to months. > > How can it be done? > > Also i want to be able to compare data for multiple customers i.e. show > hide series. > > Pls help > -- 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.
