If you want your events to show up in the legend, currently you will have to create a separate column for each.
We are thinking of adding a 'series' role to do something close to what you want, but not today. On Tue, Apr 25, 2017 at 6:29 PM, sachin pawar <[email protected]> wrote: > Hello folks, > i just went through below link and came to know of google charts. > > https://carlos-sierra.net/2014/07/28/free-script-to- > generate-a-line-chart-on-html/ > > i have below question. > > i have one question. > Lets say i have below kind of data ( the data is present in the attached > excel file ash_eg.xlsx). > > TIME – containing the sample time from ash truncated to MM/DD/YYYY-HH24:MI > W – containing the wait event, if none, then CPU. > SMPL – count of samples for that event in that “TIME” minute > > > TIME W SMPL > 4/13/2017-19:44 CPU 1 > 4/13/2017-19:46 log file sync 1 > 4/13/2017-19:46 CPU 1 > 4/13/2017-19:46 CPU 1 > 4/13/2017-19:47 db file sequential read 1 > 4/13/2017-19:47 db file sequential read 1 > 4/13/2017-19:47 log file sync 1 > 4/13/2017-19:47 CPU 1 > 4/13/2017-19:47 CPU 1 > 4/13/2017-19:48 CPU 1 > 4/13/2017-19:49 CPU 1 > 4/13/2017-19:50 db file sequential read 1 > 4/13/2017-19:50 flashback log file sync 1 > 4/13/2017-19:50 log file sync 4 > 4/13/2017-19:50 control file sequential read 1 > 4/13/2017-19:50 log file parallel write 1 > 4/13/2017-19:50 flashback log file write 1 > 4/13/2017-19:51 db file sequential read 1 > 4/13/2017-19:52 CPU 1 > 4/13/2017-19:52 null event 1 > > > > i want to make a stacked area chart using google charts only.Like the one > given below > > > <https://lh3.googleusercontent.com/-qUduOucgHN0/WP_NeuJnctI/AAAAAAAAAOA/knHJG7SU-fI5DMVbQPxLqrFFHDck-sWgwCLcB/s1600/objective.JPG> > > > As you can see each wait event is shown with different color, but all > those wait events are in a single column i.e. *W* > > > My requirement is : > w should be a variable where the value of the event will result in a > different color. > I dont want to make a different column for each wait separately. > How can i achieve that? > > I am looking for a kind of graph ( unfortunately there is not image copy > paste option to show exactly) which i can get if i copy the above data in > an excel and make a pivot chart: > AXIS(categories)-TIME > LEGEND(series)-W > VALUES-Sum of SMPL > > Regds > > > Sachin > > -- > 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 google-visualization-api@ > googlegroups.com. > Visit this group at https://groups.google.com/ > group/google-visualization-api. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/google-visualization-api/057b32e9-a23b-4ea0-8991- > 2e08fde40a99%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/057b32e9-a23b-4ea0-8991-2e08fde40a99%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJOVELjhK3%2BF20P826u-rzd0OHM9HZkNGHLK_RtFr9NC7Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
