how to write expression for google maps?

[buzzy996]

hi guys,

i have 500 records in a table along with country names.

i got GOOGLE MAP in qlick view  along with records as india-400,china-100

but the things is,i need to disply onmap PERCENTAGE OF THOSE RECORDS!!!,HOW TO CALCULATE PERCENTAGE in expression?

formula:- number of records with respect to the country / total number of reocrds.

thx

[buzzy996]

yes,ur right but when i selected FinYR from slection box values are not updating accordingly on map?

can i know wht was the cause?

[#3 · Accepted solution]

only you can answer

you can do count(key1)

but if there is only one location on each lon-lat you can do like i write before:)

[buzzy996]

Thanks Pari

[vikasmahajan]

If you have sample demo for same please share for INDIA