Cannot get more than one category to display in motion chart...

23 views
Skip to first unread message

BigJoe

unread,
Aug 26, 2011, 12:28:22 PM8/26/11
to Google Visualization API
Trying to get the following code to run and allow for the display of
multiple "Regions" (i.e. last column).

Only "Region 6" displays in the motionchart. I see that this has been
addressed in previous discussions but the current motionchart
documentation indicates that columns 4 and above can be string or
numeric.

Any thoughts?

<script type="text/javascript" src="http://www.google.com/jsapi"></
script>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['motionchart']});

function drawVisualization() {
var data = new google.visualization.DataTable();

data.addColumn('string', 'Category');
data.addColumn('number', 'Year');
data.addColumn('number', 'Count');
data.addColumn('string', 'Region');
data.addRows([
['Founded',2004,1291,'Region 1'],
['Founded',2004,970,'Region 2'],
['Founded',2004,1481,'Region 3'],
['Founded',2004,1227,'Region 4'],
['Founded',2004,1018,'Region 5'],
['Founded',2004,1662,'Region 6'],
['Founded',2005,1476,'Region 1'],
['Founded',2005,1248,'Region 2'],
['Founded',2005,1511,'Region 3'],
['Founded',2005,1033,'Region 4'],
['Founded',2005,1039,'Region 5'],
['Founded',2005,1538,'Region 6'],
['Founded',2006,1472,'Region 1'],
['Founded',2006,1205,'Region 2'],
['Founded',2006,1353,'Region 3'],
['Founded',2006,1167,'Region 4'],
['Founded',2006,1018,'Region 5'],
['Founded',2006,1508,'Region 6'],
['Founded',2007,1419,'Region 1'],
['Founded',2007,1263,'Region 2'],
['Founded',2007,1300,'Region 3'],
['Founded',2007,1269,'Region 4'],
['Founded',2007,951,'Region 5'],
['Founded',2007,1180,'Region 6'],
['Founded',2008,1394,'Region 1'],
['Founded',2008,1008,'Region 2'],
['Founded',2008,1285,'Region 3'],
['Founded',2008,1188,'Region 4'],
['Founded',2008,1107,'Region 5'],
['Founded',2008,1128,'Region 6'],
['Inconclusive',2004,2484,'Region 1'],
['Inconclusive',2004,1830,'Region 2'],
['Inconclusive',2004,3485,'Region 3'],
['Inconclusive',2004,2821,'Region 4'],
['Inconclusive',2004,2116,'Region 5'],
['Inconclusive',2004,3418,'Region 6'],
['Inconclusive',2005,2151,'Region 1'],
['Inconclusive',2005,1539,'Region 2'],
['Inconclusive',2005,3175,'Region 3'],
['Inconclusive',2005,2443,'Region 4'],
['Inconclusive',2005,2112,'Region 5'],
['Inconclusive',2005,2915,'Region 6'],
['Inconclusive',2006,2352,'Region 1'],
['Inconclusive',2006,1382,'Region 2'],
['Inconclusive',2006,2541,'Region 3'],
['Inconclusive',2006,2611,'Region 4'],
['Inconclusive',2006,1961,'Region 5'],
['Inconclusive',2006,3111,'Region 6'],
['Inconclusive',2007,2533,'Region 1'],
['Inconclusive',2007,1222,'Region 2'],
['Inconclusive',2007,2255,'Region 3'],
['Inconclusive',2007,2661,'Region 4'],
['Inconclusive',2007,2016,'Region 5'],
['Inconclusive',2007,2566,'Region 6'],
['Inconclusive',2008,2024,'Region 1'],
['Inconclusive',2008,861,'Region 2'],
['Inconclusive',2008,2063,'Region 3'],
['Inconclusive',2008,2249,'Region 4'],
['Inconclusive',2008,1723,'Region 5'],
['Inconclusive',2008,1799,'Region 6'],
['No Finding',2004,461,'Region 1'],
['No Finding',2004,327,'Region 2'],
['No Finding',2004,847,'Region 3'],
['No Finding',2004,600,'Region 4'],
['No Finding',2004,324,'Region 5'],
['No Finding',2004,476,'Region 6'],
['No Finding',2005,214,'Region 1'],
['No Finding',2005,112,'Region 2'],
['No Finding',2005,453,'Region 3'],
['No Finding',2005,399,'Region 4'],
['No Finding',2005,158,'Region 5'],
['No Finding',2005,193,'Region 6'],
['No Finding',2006,151,'Region 1'],
['No Finding',2006,107,'Region 2'],
['No Finding',2006,95,'Region 3'],
['No Finding',2006,391,'Region 4'],
['No Finding',2006,81,'Region 5'],
['No Finding',2006,135,'Region 6'],
['No Finding',2007,137,'Region 1'],
['No Finding',2007,107,'Region 2'],
['No Finding',2007,128,'Region 3'],
['No Finding',2007,340,'Region 4'],
['No Finding',2007,128,'Region 5'],
['No Finding',2007,94,'Region 6'],
['No Finding',2008,221,'Region 1'],
['No Finding',2008,73,'Region 2'],
['No Finding',2008,126,'Region 3'],
['No Finding',2008,459,'Region 4'],
['No Finding',2008,234,'Region 5'],
['No Finding',2008,113,'Region 6'],
['Unfounded',2004,1872,'Region 1'],
['Unfounded',2004,1638,'Region 2'],
['Unfounded',2004,2212,'Region 3'],
['Unfounded',2004,2563,'Region 4'],
['Unfounded',2004,2218,'Region 5'],
['Unfounded',2004,2195,'Region 6'],
['Unfounded',2005,2598,'Region 1'],
['Unfounded',2005,1966,'Region 2'],
['Unfounded',2005,3852,'Region 3'],
['Unfounded',2005,3537,'Region 4'],
['Unfounded',2005,2868,'Region 5'],
['Unfounded',2005,3208,'Region 6'],
['Unfounded',2006,2401,'Region 1'],
['Unfounded',2006,2036,'Region 2'],
['Unfounded',2006,3716,'Region 3'],
['Unfounded',2006,3904,'Region 4'],
['Unfounded',2006,2783,'Region 5'],
['Unfounded',2006,2679,'Region 6'],
['Unfounded',2007,2649,'Region 1'],
['Unfounded',2007,2042,'Region 2'],
['Unfounded',2007,3690,'Region 3'],
['Unfounded',2007,4159,'Region 4'],
['Unfounded',2007,2624,'Region 5'],
['Unfounded',2007,2442,'Region 6'],
['Unfounded',2008,3115,'Region 1'],
['Unfounded',2008,2519,'Region 2'],
['Unfounded',2008,4061,'Region 3'],
['Unfounded',2008,4985,'Region 4'],
['Unfounded',2008,3331,'Region 5'],
['Unfounded',2008,2901,'Region 6']


]);





var motionchart = new google.visualization.MotionChart(
document.getElementById('visualization'));
motionchart.draw(data, {'width': 800, 'height': 400});
}


google.setOnLoadCallback(drawVisualization);
</script>

Amr Salah

unread,
Nov 29, 2011, 3:22:29 AM11/29/11
to google-visua...@googlegroups.com
Dear Sir/Madam,

I have the pleasure to brief you on our Data Visualization software
"Trend Compass".

TC is a new concept in viewing statistics and trends in an animated
way by displaying in one chart 5 axis (X, Y, Time, Bubble size &
Bubble color) instead of just the traditional X and Y axis. Discover
trends hidden in spreadsheets. It could be used in analysis,
research, presentation etc. In different business sectors, to name a
few we have Deutsche Bank, NBC Universal, RIM,  Vanguard
Institutional Investor, Ipsos, Princeton University as our clients.

NBC presentation on TED using Trend Compass exported Videos. Now on
CNN Money / Fortune (Dec 21st,2010):
http://tech.fortune.cnn.com/2010/12/21/from-laughing-to-judging-in-fifty-years-the-evolution-of-televised-emotion/

The following link is for our new Geographical Trend Compass
(Earthquake in Japan - Mag vs Depth vs Time):
http://www.epicsyst.com/test/v2/japan-earthquake

Link on Ads Monitoring on TV Satellite Channels. Pick Duration (Ads
daily duration) vs Repeat (Ads repetition per day).
http://www.epicsyst.com/test/v2/tv-monitor/

Link showing drilling feature (Parent/Child) - Just double-click on any
bubble:
http://www.epicsyst.com/test/v2/drilling/

Link on UK Master Card vs Visa performance :
http://www.epicsyst.com/test/v2/mastercard_vs_visa/

Links on Funds:
http://www.epicsyst.com/test/v2/best_exchange_traded_funds/
http://www.epicsyst.com/test/v2/us_insurance_funds/
http://www.epicsyst.com/test/v2/aaim_fund_performance/

Link on other KPIs :
http://www.epicsyst.com/test/v2/hospital_performance/
http://www.epicsyst.com/test/v2/international_insurance/

Link on Chile's Earthquake (Feb 27th 2010):
http://www.epicsyst.com/test/v2/EarthQuakeinChile/

This a link on weather data :
http://www.epicsyst.com/test/v2/aims/

This is a bank link to compare Deposits, Withdrawals and numbers of
Customers for different branches over time ( all in 1 Chart) :
http://www.epicsyst.com/test/v2/bank-trx/

Misc Examples :
http://www.epicsyst.com/test/v2/airline/
http://www.epicsyst.com/test/v2/stockmarket1/
http://www.epicsyst.com/test/v2/football/
http://www.epicsyst.com/test/v2/swinefludaily/
http://www.epicsyst.com/test/v2/babyboomers/

This is a project we did with Princeton University on US unemployment :
http://www.epicsyst.com/main3.swf

A 3 minutes video presentation of above by Professor Alan Krueger
Bendheim Professor of Economics and Public Affairs at Princeton
University and currently Chief Economist at the US Treasury using
Trend Compass :
http://epicsyst.com/trendcompass/princeton.aspx?home=1

You can download a trial version. It has a feature to export
EXE,PPS,HTML and AVI files. The most impressive is the AVI since you
can record Audio/Video for the charts you create.

http://epicsyst.com/trendcompass/FreeVersion/TrendCompassv1.2_DotNet.zip

All the best.

Amr Salah
Trend Compass Team
Epic Systems
www.epicsyst.com


Roni Biran

unread,
Nov 29, 2011, 3:31:16 AM11/29/11
to google-visua...@googlegroups.com
Hi there Amr,

What you posted here is really not cool.
This group is dedicated for the use of Google visualization API and not a platform for business advertising. More over, your products use flash, meaning that they will not work on all mobile platforms, whereas the Google visualization API returns pure HTML and JavaScript.
So before you post things like that in the future, please look at what platform you're doing that.

Regards,


--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/fUP3P1eesDYJ.

To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

Reply all
Reply to author
Forward
0 new messages