Hello,
i am using the google geo chart via webviever in my Filemaker database. The
chart shows every country with a marker. The most countries have a value of
0( it is called Anzahl in my code) and i do not want them to show up in my
chart. Is it possible to hide them? Only the countries with value=0.
This is my code, hope someone can help me!!!
"data:text/html," & "
<html>
<head>
<script type='text/javascript'
src='https://www.google.com/jsapi'></script>
<script type='text/javascript'>
google.load('visualization', '1', {'packages': ['geochart']});
google.setOnLoadCallback(drawMarkersMap);
function drawMarkersMap() {
var data = google.visualization.arrayToDataTable([
['City', 'Anzahl' ],
['Albanien'," & Spieler::Summe Albanien & "],
['Andorra'," & Spieler::Summe Andorra & "],
['Armenien'," & Spieler::Summe Armenien & "],
['Aserbaidschan'," & Spieler::Summe Aserbaidschan & "],
['Belgien'," & Spieler::Summe Belgien & "],
['Bosnien und Herzegowina'," & Spieler::Summe Bosnien & "],
['Bulgarien'," & Spieler::Summe Bulgarien & "],
['Dänemark'," & Spieler::Summe Dänemark & "],
['Deutschland'," & Spieler::Summe Deutschland & "],
['GB-ENG'," & Spieler::Summe England & "],
['Estland'," & Spieler::Summe Estland & "],
['Färöer'," & Spieler::Summe Färöer & "],
['Finnland'," & Spieler::Summe Finnland & "],
['Frankreich'," & Spieler::Summe Frankreich & "],
['Georgien'," & Spieler::Summe Georgien & "],
['Gibraltar'," & Spieler::Summe Gibraltar & "],
['Griechenland'," & Spieler::Summe Griechenland & "],
['Irland'," & Spieler::Summe Irland & "],
['Island'," & Spieler::Summe Island & "],
['Israel'," & Spieler::Summe Israel & "],
['Italien'," & Spieler::Summe Italien & "],
['Kasachstan'," & Spieler::Summe Kasachstan & "],
['Kosovo'," & Spieler::Summe Kosovo & "],
['Kroatien'," & Spieler::Summe Kroatien & "],
['Lettland'," & Spieler::Summe Lettland & "],
['Liechtenstein'," & Spieler::Summe Liechtenstein & "],
['Litauen'," & Spieler::Summe Litauen & "],
['Luxemburg'," & Spieler::Summe Luxemburg & "],
['Malta'," & Spieler::Summe Malta & "],
['Mazedonien'," & Spieler::Summe Mazedonien & "],
['Moldawien'," & Spieler::Summe Moldawien & "],
['Montenegro'," & Spieler::Summe Montenegro & "],
['Niederlande'," & Spieler::Summe Niederlande & "],
['GB-NIR'," & Spieler::Summe Nordirland & "],
['Norwegen'," & Spieler::Summe Norwegen & "],
['Österreich'," & Spieler::Summe Österreich & "],
['Polen'," & Spieler::Summe Polen & "],
['Portugal'," & Spieler::Summe Portugal & "],
['Rumänien'," & Spieler::Summe Rumänien & "],
['Russland'," & Spieler::Summe Russland & "],
['San Marino'," & Spieler::Summe San Marino & "],
['GB-SCT'," & Spieler::Summe Schottland & "],
['Schweden'," & Spieler::Summe Schweden & "],
['Schweiz'," & Spieler::Summe Schweiz & "],
['Serbien'," & Spieler::Summe Serbien & "],
['Slowakei'," & Spieler::Summe Slowakei & "],
['Slowenien'," & Spieler::Summe Slowenien & "],
['Spanien'," & Spieler::Summe Spanien & "],
['Tschechien'," & Spieler::Summe Tschechien & "],
['Türkei'," & Spieler::Summe Türkei & "],
['Ukraine'," & Spieler::Summe Ukraine & "],
['Ungarn'," & Spieler::Summe Ungarn & "],
['GB-WLS'," & Spieler::Summe Wales & "],
['Weißrussland'," & Spieler::Summe Weißrussland & "],
['Zypern'," & Spieler::Summe Zypern & "],
]);
var options = {
sizeAxis: {minValue: 0.00000000001, maxSize: 10},
width: 500, height: 360,
colorAxis: {colors: ['#00853f', 'black', '#e31b23']},
backgroundColor: '#81d4fa',
datalessRegionColor: '#f8bbd0',
region: 'world',
displayMode:'markers',
};
var chart = new
google.visualization.GeoChart(document.getElementById('chart_div'));
chart.draw(data, options);
};
</script>
</head>
<body>
<div id=\"chart_div\" style=\"width: 500px; height: 360px;\"></div>
</body>
</html>"
--
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.
For more options, visit https://groups.google.com/d/optout.