{"id":130,"date":"2009-07-15T03:11:00","date_gmt":"2009-07-15T10:11:00","guid":{"rendered":"http:\/\/rajiniravi.com\/ravi\/wp\/?p=130"},"modified":"2009-07-15T03:11:00","modified_gmt":"2009-07-15T10:11:00","slug":"google-motion-charts","status":"publish","type":"post","link":"https:\/\/ravi.rajiniravi.com\/blog\/2009\/07\/google-motion-charts\/","title":{"rendered":"Google Motion Charts"},"content":{"rendered":"<p>A few days back, I saw Hans Rosling <a href=\"http:\/\/www.ted.com\/talks\/hans_rosling_the_truth_about_hiv.html\" target=\"_blank\">visualize HIV data<\/a> in this presentation at TED talks. I was looking for (to purchase or create) such a graphing tool for quite some time (incidentally, my requirement is a combo of heat map, bar\/pie chart &amp; motion chart). A little research revealed that Google purchased Trendalyzer, the graphing tool used in this presentation, from his company <a href=\"http:\/\/www.gapminder.org\/\" target=\"blank\">Gapminder<\/a> in March 2006. A version of it has been integrated into <a href=\"http:\/\/docs.google.com\/support\/bin\/answer.py?hl=en&amp;answer=91610\" target=\"_blank\">Google Spreasheets<\/a> as Motion Chart.<\/p>\n<p>Luckily, I found some <a href=\"http:\/\/deadpresident.blogspot.com\/2009\/07\/gsm-figures-june-2009.html\" target=\"_blank\">Indian Mobile-GSM subscriber data<\/a> during the same time, cleaned it a bit, added some data and here&#8217;s how the trend looks&#8230;<\/p>\n<p><script src=\"http:\/\/spreadsheets.google.com\/gpub?url=http%3A%2F%2Foj0ijfii34kccq3ioto7mdspc7r2s7o9.spreadsheets.gmodules.com%2Fgadgets%2Fifr%3Fup__table_query_url%3Dhttp%253A%252F%252Fspreadsheets.google.com%252Ftq%253Frange%253DA1%25253AG641%2526gid%253D0%2526headers%253D-1%2526key%253D0AhyVYQwg-7a_dEVHeHNCdEFtRnh2cDRBMUVQVjByc1E%2526pub%253D1%26up_title%3DIndia%2520Mobile%2520Subscriber%2520base%2520-%2520GSM%2520%26up_initialstate%3D%26up__table_query_refresh_interval%3D300%26url%3Dhttp%253A%252F%252Fwww.google.com%252Fig%252Fmodules%252Fmotionchart.xml&amp;height=465&amp;width=585\"><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few days back, I saw Hans Rosling visualize HIV data in this presentation at TED talks. I was looking for (to purchase or create) such a graphing tool for quite some time (incidentally, my requirement is a combo of heat map, bar\/pie chart &amp; motion chart). A little research revealed that Google purchased Trendalyzer, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3979,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"book_review_cover_url":"","book_review_title":"","book_review_series":"","book_review_author":"","book_review_genre":"","book_review_isbn":"","book_review_publisher":"","book_review_release_date":"","book_review_format":"","book_review_pages":"","book_review_source":"","book_review_rating":"","book_review_summary":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8,10],"tags":[21,49],"class_list":["post-130","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","category-trends","tag-google","tag-visualization"],"jetpack_featured_media_url":"https:\/\/ravi.rajiniravi.com\/blog\/wp-content\/uploads\/2021\/01\/photo-1547139559-c89c59d117611.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":0,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/media\/3979"}],"wp:attachment":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}