Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
The Twine forums are now archived. If you need help, please visit http://help.supermechanical.com
Plotting magswitch states on a timeline in a Google spreadsheet?
Following a thread regarding combining Twine and IFTTT, I've created an autoupdating spreadsheet, which saves all the magswitch state changes like this:
January 11, 2013 at 07:41PM Closed
January 11, 2013 at 07:41PM Open
January 11, 2013 at 07:52PM Closed
Now, is there a way to plot a timeline based on this data, that would graphically show for how long each state lasted? I imagine this would require reformatting the time and finding a proper visualisation type, but really no idea how to do this. Anyone tried anything similar? Thanks!
January 11, 2013 at 07:41PM Closed
January 11, 2013 at 07:41PM Open
January 11, 2013 at 07:52PM Closed
Now, is there a way to plot a timeline based on this data, that would graphically show for how long each state lasted? I imagine this would require reformatting the time and finding a proper visualisation type, but really no idea how to do this. Anyone tried anything similar? Thanks!
Best Answer
-
2 Comments sorted by Votes Date Added
-
You might try doing something similar to this: http://community.supermechanical.com/index.php?p=/discussion/264/twine-and-thingspeak-com
Thingspeak will plot the data for you and give you easy access to use the data in a different visualization.