How to show growth per country?

[Darius]

Hi all,

I am new to Xcelsius and I try to use the map functionality to show growth in different countries.

Is there any way to display for example bigger (increasing width and height) icons on bigger value, to highlight bigger countries?

Please take a look at my screenshot, to better understand what I am trying to do:

[https://wiki.sdn.sap.com/wiki/download/attachments/107774483/xcelsius.png]

[Former Member · Accepted solution]

Darius,

Increasing the size of the icon may not be the best way to visualize this data. Using the alerts tab in your properties should give you better control. See the image:

http://www.freeimagehosting.net/uploads/84486d1e5a.png

If you still want to stick with the increasing sized icons it is better to define value ranges and then associate those value ranges to different sized icons and set them to be dynamically visible. For example:

1) Create three icons for each country

smallicon = 0 to 20

medicon = 21 to 51

bigicon = 51 to 100

2) Create a IF statement to control the visibility based on value range

[Darius · Accepted solution]

Hi Ryan, I really like the alert method you have illustrated. could you send me the related xcelsius xif file for testing purpose?

You can find my address in my [business card|http://www.sdn.sap.com/irj/scn/bc?u=h%2bxt65aov2u%3d]

Best regards,

Darius

[Former Member · Accepted solution]

Darius,

Sent as requested. But I am using Xcelsius with SP3 so you may have to install the same SP to view the report.

All the best.

Ryan

[Former Member]

Hi Darius

Use a Bubble chart strategically placed over the world map and use it's bubble size properties to do what you need.

Regards

[Charles|http://www.reportex.co.uk]