Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
daniel_robu
Contributor II
Contributor II

Geographical heat map using Google chart API - '&chd=s:' parameter wrong display

From cookbook of Rob Wunderlich I made some modification on the file GoogleChartMap to adapt on the Romanian map but I got stuck on the last parameter

& '&chd=s:' & concat(  aggr(  mid('$(simpleEncodingMap)', 1+round(61*sum(Sales)/max(TOTAL aggr(DISTINCT sum(Sales), State)),1),1), State), '',

fieldIndex('State', State))

I replace State with ISO2, the map is showing but when I select de sume value of a County is showing the dates for other county.

e.g. :I press on RO-BC and the map select RO-HD

Somenone could help or explain more clearly the whole parameter  (aggr(  mid('$(simpleEncodingMap)', 1+round(61*sum(Sales)/max(TOTAL

aggr(DISTINCT sum(Sales)  ?

0 Replies