# Dynamic tooltips for map

Hi ,

PFA workbook.

In map tooltip, I need to display quantity against Ship Mode(dimension). This should be dynamic.

Suppose if we see in Sheet2 ,

state 'Wyoming' has only 'Standard Class' in Ship mode while 'West Virginia' has 'Standard Class' , 'Same Day' in Ship mode.

So, in the map, if I hover over 'Wyoming' only 'Standard Class' should be displayed.

If I hover over  'West Virginia' , 'Standard Class' , 'Same Day' should be displayed.

But in the calculated fields Standard class, Same Day, I need to use aggregate function  i.e., sum(Quantity) according to my requirement.

i.e., the below formulae

I can't use the below formula because of certain requirements.

Can anyone suggest ideas to achieve this.

• ###### 1. Re: Dynamic tooltips for map

Hi Deepthi,

Here is a quick fix, that shall work if you have two shipping modes at maximum. You might of course create nested calculation. Create this calculated field and drop it on the Tooltip.

If MIN([Ship Mode]) = MAX([Ship Mode]) THEN MIN([Ship Mode]) ELSE "Standard Class, Same Day" END

BR

• ###### 2. Re: Dynamic tooltips for map

It works for West Virginia.

But there are other states which has 4 different ship modes.

For e.g., Alabama.

I want this to be dynamic.

Thanks,

Deepthi.

• ###### 3. Re: Dynamic tooltips for map

Hi,

BR

• ###### 4. Re: Dynamic tooltips for map

Hi Deepthi,

Please find the solution attached with quantity in the tooltip.

BR

1 of 1 people found this helpful
• ###### 5. Re: Dynamic tooltips for map

Thanks for the help.

Need help in one more point.

Can we combine these calculated fields together, so that I don't get empty space in tooltip, for countries where few ship modes are unavailable. For e.g., for Wyoming

• ###### 6. Re: Dynamic tooltips for map

Hi Deepthi,

It might be possible but can't think of simple solution

What I would have done, is to check which ship mode is most used, then I would change their location in the tooltip. In that way, the gaps would always be on the down part of the tooltip.

Or you might put them all in one line but it might not be visually good.

BR