Select locations and visualize user entry in scatter chart

[#1]

Hi,

I need to select a number of locations (lets say 25) from a locations table which hold ZIP, GPS-Lon, GPS-Lat.

I then need to visualize 25 manual user entries (representing a radius each) as dot sizes.

How can I collect user input (one for each selected location) and "bind" it to those 10 locations so that I can have a nice scatter chart (locations map)?

Best regards,
Georg

[brenner_martina · Accepted solution]

Hi Georg,

you must enter at the beginning of your script:

Inputfield Fieldname;

than enter in the Table with the locations:

Load ...,
0 as Fieldname,
...
From ...;

or, if you want to preset your Fieldname with a value:

Load ...,
Valuefiled as Fieldname,
...
From ...;

Now you can enter in your tablechart or pivottable the new Filedname and use here the expression:

Inputsum(Fieldname,'*')

if you want to calculate these values.

[#3]

Thanks Martina, that was exactly what I missed!

Best regards,
Georg