0 Replies Latest reply: Jun 9, 2012 3:58 PM by Daniel Robu RSS

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

    Daniel Robu

      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)  ?