Hi Sergey, thanks for your help! Can you give me an example how i use the filter method in my code?
Am Montag, 1. Dezember 2014 17:33:19 UTC+1 schrieb Sergey: > > Hi, there's no option to do this in the GeoChart. However, you could use > the DataView#getFilteredRows method to filter those rows out. You can find > the documentation for it here: > https://developers.google.com/chart/interactive/docs/reference#DataView > > On Fri Nov 28 2014 at 4:44:58 PM Dustin Böttger <[email protected] > <javascript:>> wrote: > >> 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] >> <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/ >> group/google-visualization-api. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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.
