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,
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
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.##','.',','))
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