Doug,
Becareful though. What you said is true as long as the average stays =
constant at 10. Unfortunately you cannot include an aggregate function =
in a thematic expression. Chance of the average staying the same is zero =
or almost zero and when opening your workspace some time in the future, =
you never going to remember that there is a hidden average typed there.=20
Laurence Seeff
Points Business Mapping Ltd.
22 Tuval St., Ramat Gan, 52522, Israel
=20
Tel: +972-3-6126216
Fax: +972-3-6126323
Email: [EMAIL PROTECTED]
Web: www.points.co.il
----- Original Message -----=20
From: Douglas Cubin=20
To: 'Brendan.O'[EMAIL PROTECTED]' ; 'MI-List'=20
Sent: Tuesday, November 27, 2001 3:41 PM
Subject: RE: MI-L A simple thematic question
Brendan
Note that if you save this as a workspace then when you update the =
values in
your currency field, your thematic will be updated. The thematic =
expression
is dynamically recreated. Handy!
Doug
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Laurence
Seeff
Sent: 27 November 2001 13:27
To: Brendan.O'[EMAIL PROTECTED]; MI-List
Subject: Re: MI-L A simple thematic question
Hi,
You average is constant throughout (12+10+8)/3=3D3D10
Instead of selecting the currency field for the thematic value, go to =
=3D
the end of the list and choose expression. Here you can build your =3D
expression:
currency_amount/10
This will produce your thematic map.
Laurence Seeff
Points Business Mapping Ltd.
22 Tuval St., Ramat Gan, 52522, Israel
=3D20
Tel: +972-3-6126216
Fax: +972-3-6126323
Email: [EMAIL PROTECTED]
Web: www.points.co.il
----- Original Message -----=3D20
From: Brendan.O'[EMAIL PROTECTED]=3D20
To: [EMAIL PROTECTED]=3D20
Sent: Tuesday, November 27, 2001 2:57 PM
Subject: MI-L A simple thematic question
Hi experts,
I have a table of regions with currency amounts against each region. =
I =3D
wish
to thematically map the ratio of the currency amount for each region =
=3D
to the
average (currency amount) for all regions. The averages are not =3D
recorded
in the table.
What is the elegant way of doing this.
example
Data as it is
Region Name Euros
Smithboro 12
Jonesville 10
Someplace 8
with the above data I would be seeking to thematically represent =3D
values of
Region Name Ratio
Smithboro 12/((12+10+8)/3)
Jonesville 10/((12+10+8)/3)
Someplace 8/((12+10+8)/3)
i.e
Region Name Ratio
Smithboro 1.2
Jonesville 1.0
Someplace 0.8
Regards
Brendan O'Donovan Snr Exploration Geologist Outokumpu Tara Mines =3D
Ireland.
=3D
=
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com =
|
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
=
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
____________________________________________________________________
If this email isn't for you then we'd be grateful if you could let our
helpdesk know there's been a mistake by putting 'received in=20
error' in the subject box and sending it to [EMAIL PROTECTED]=20
If it isn't for you, we're sure you'll understand that you're not=20
allowed to copy, disclose or distribute any of its contents. =20
This email is private and confidential and may also be privileged,
so if you shouldn't have received it, we'd be grateful if you could =
delete it.
Thanks.
________________________________________________________________
=
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
