how to add expression in google map api using scatter chart

[#1]

Hi,

I'm trying to design a heat map using scatter chart (with google API).

With the help of the document provided from our community, I made a basic google map using scatter chart.

My map is now showing Area wise Number of Patients.

i.e (When i mouse over the point on map it is showing Area name and Count of patients).

For each area I'm having Diseases also.

So, I need to show the Number of patients under each disease and Area wise.

i.e (When i mouse over the point i need to get the area name and disease name-Patient Count).

The step by step design document is attached. Kindly find the attachment and screen shot of my map.

Kindly help me.

Thanks,

Adithyan

[Marcio_Campestrini]

Adithyan

To see what you want I suggest you two ways:

1) Create various expressions (after the third expression) in your chart, selecting in 'Display Options" the Text as Pop-up option

2) Create one expression (the forth expression of your chart) and to concatenate the diseases using Concat.

Hope this help you.

[#3]

Hi Marcio,

Thanks for your reply.

I had tried your suggestion. But still I'm not getting.

Can you help me to write the concat expression.

my dimensions are, AreaName,DiseaseName & PatientId.

Thanks,

Adithyan

[Marcio_Campestrini]

Hi Adithyan    

With Concat: Concat(value, separator), like Concat(AreaName, ',')

With &: AreaName & ' - ' & DiseaseName...

Or create a table to shw the data when selecting a value in your map.

[Marcio_Campestrini]

Hi

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

[Marcio_Campestrini]

Got you issue solved? Please mark helpful/correct answers.