Google Api Heat map

[#1]

Hi all,

I am using the latest google api to visualize a heat map with countries.

Although it seems that my expression calculations are correct, each number of observations do no map to the correct country.

Find my text box exp below:

='http://chart.googleapis.com/chart?'

      & 'chf=bg,s,a0c2ff'  /*Background color */

      & '&chs=460x320&cht=map:fixed=-75,-180,85,180' //Chart Size, Zoom Type and Boundary

      & '&chco=' & '808080'  /* Color for no dimension value */

      & ',' & $(vColorSelect) /*Color Gradient, from left to right - no measure value to highest measure value*/

      & '&chld=' & concat(DISTINCT [Origin Country Code], '|', fieldIndex('[Origin Country Code]', [Origin Country Code])) /*list of dimension value*/

      & '&chd=t:' & concat(ceil(100*aggr(sum($(vMeasureSelect))/max(TOTAL aggr(DISTINCT sum($(vMeasureSelect)), [Origin Country Code])), [Origin Country Code])), ',', [Origin Country Code])

      /*list of measure values for driving the intensity of color for each dimension member*/

Any ideas why is this happening??

[fkeuroglian]

Please put an example attached

thank you

[#3]

Hi Fernando,

You can find a sample attached.

[#4 · Accepted solution]

I managed to resolve the issue on my own.

It all came down to the sorting of the HeatMap values. I added a new field in the script that corresponded to the sort of values. In that way the correct values were mapped to the countries.

Thanks anyway