Sorry Th, DataViews cannot do the transpose operation on the data. You'd have to write a loop to do that yourself, or perhaps use a Query with the pivot clause: https://developers.google.com/chart/interactive/docs/querylanguage#pivot
On Fri, Oct 30, 2015 at 4:51 PM, Th Mrckx <[email protected]> wrote: > Hi Google Vis community, > > I am trying to make a visual representation (using charts) of some data I > have in a google spreadsheet > <https://docs.google.com/spreadsheets/d/1GmFaGCgcHWGWfT8rCWvD4QJ1Ed-Hn7LIMJ5SXFTmdc8/pubhtml> > . > This data will be embedded on a website using html. > I get to the point where I can see the data from the spreadsheet. So far, > so good. > > Trouble begins when I try to adjust my dataTable to a dataView and alter > that dataview to fit the charts specific needs. > What I'm basically looking for is a way to transpose and then filter data > so only certain columns (or rows) remain. > > To try and be as specific as possible I added a small portion of my data > in this google spreadsheet > <https://docs.google.com/spreadsheets/d/1GmFaGCgcHWGWfT8rCWvD4QJ1Ed-Hn7LIMJ5SXFTmdc8/pubhtml> > on the sheet named 'original'. > What I want to achieve by transposing is found on the sheet named > 'transposed' and finally you can see the data that has to remain as well as > the chart I'm trying to create. > > I hope I'm clear on my problem. If anything remains unclear, please let me > know. > > Thanks for any assistance! > > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/cce6bffb-764c-461e-80ff-cd084449d4be%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/cce6bffb-764c-461e-80ff-cd084449d4be%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> - 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. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPVjdzYcuYqzOEexvY2ZxxfctUjAMH%3DBuUv2Ve5a-m-3Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
