Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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,
 
					
				
		
.png) JonnyPoole
		
			JonnyPoole
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 jochem_zw
		
			jochem_zw
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.##','.',','))
 
					
				
		
.png) JonnyPoole
		
			JonnyPoole
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 
					
				
		
Thanks Jonathan & Jochem,
Had to implement both your suggestions however my points are now dynamically resizing.
Now onto the next head wrecker! thanks again
