Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mapquest Map, Points not autosizing

Hi Folks,

I have created the attached map of Ireland plotting some counties (all containing random data) then using the MapQuest connection plotting it against a map to show in the correct location. 

I am looking to have each county point increase or decrease depending on the quantity of sales, I have tried various methods for this however the points stay resolutely uniform in size.   

Is there a way to have them dynamically resize? Its probably something simple that I'm missing...

thanks in advance,

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

Played around with your number formatting in the script i changed 2 areas:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

to

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

and

    Replace([results/result/locations/location/latLng/lat], '.', ',')as latitude,
Replace([results/result/locations/location/latLng/lng], '.', ',')

as longitude

to

    Replace([results/result/locations/location/latLng/lat], ',', '.')as latitude,
Replace([results/result/locations/location/latLng/lng], ',', '.')as longitude

...then hit reload and it should work

View solution in original post

3 Replies
jochem_zw
Employee
Employee

Your number format for the CustomerQuantity is not correct.

If you do a sum on this field it returns 0.

maybe this can help you:

sum(num#(CustomerQuantity,'#,##0.##','.',','))

JonnyPoole
Former Employee
Former Employee

Played around with your number formatting in the script i changed 2 areas:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

to

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

and

    Replace([results/result/locations/location/latLng/lat], '.', ',')as latitude,
Replace([results/result/locations/location/latLng/lng], '.', ',')

as longitude

to

    Replace([results/result/locations/location/latLng/lat], ',', '.')as latitude,
Replace([results/result/locations/location/latLng/lng], ',', '.')as longitude

...then hit reload and it should work

Not applicable
Author

Thanks Jonathan & Jochem,

Had to implement both your suggestions however my points are now dynamically resizing.

Now onto the next head wrecker! thanks again