Moving data series into separate charts automatically

[farooo]

I think it would be a nice addition if we could structure our source in a way that would move the data into separate charts automatically.

[farooo]

Or it could be done by a query that we put behind our url.

[valueof]

Can you give an example?

[farooo]

I use Google Spreadsheets to automatically collect data and create the link for charted. My data has a lot of columns it looks like this on Charted. http://www.charted.co/c/832c396

The link i create in the spreadsheet looks like this to get control what is written in the fields and set the settings.

Decoded URL:
http://www.charted.co/?{"dataUrl":"https://docs.google.com/spreadsheets/d/1UFAEfjGfxuFFghAjAAC7FOunwwyAPr7AwozXY971OeU/export?gid=0&format=csv","color":"light","charts":[{"type":"line","rounding":"on","title":"Wurm Unlimited","note":"Skill Dumps"}]}

Encoded URL:
http://www.charted.co/?%7B%22dataUrl%22%3A%22https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1UFAEfjGfxuFFghAjAAC7FOunwwyAPr7AwozXY971OeU%2Fexport%3Fgid%3D0%26format%3Dcsv%22%2C%22color%22%3A%22light%22%2C%22charts%22%3A%5B%7B%22type%22%3A%22line%22%2C%22rounding%22%3A%22on%22%2C%22title%22%3A%22Wurm%20Unlimited%22%2C%22note%22%3A%22Skill%20Dumps%22%7D%5D%7D

it would be nice if we could sort columns of data via the query. So that it looks like this.
http://www.charted.co/c/d139241

I guess its maybe already possible. i just did not find any example how the query has to be structured. I think the short URL feature is hiding whats going on.

And yea my first idea was to do it via the data itself. Like add some empty column for example... but this is not a good idea i think. Via the query it would be awesome.

[valueof]

Oh wow, interesting use case! The URL version of setting parameters is there for backwards compatibility, it wasn't made to be used as API but maybe it should.

@mikesall what do you think?

[farooo]

Yea its a fun project i am working on. I love charted!!

I imagine it like this:
http://www.charted.co/?{"dataUrl":"","color":"light","chart1":[{"type":"line","rounding":"on","title":"","note":"","series":"1-2-3-4"}],"chart2":[{"type":"line","rounding":"on","title":"","note":"","series":"5-6-7-8"}] }