2 Replies Latest reply: Jun 13, 2012 5:40 AM by David Gangarossa RSS

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

    Daniel Robu

      I made some modification on the file GoogleMpaChart of Rob Wunderlich to adapt it on Romanian map but I got stuck on 'chd=s:' parameter

       

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

       

      The map is showing but the dates are not corect.

      Some help it would be apreciated or detailed of the function of  aggr(  mid('$(simpleEncodingMap)', 1+round(61*sum(Sales)/max(TOTAL aggr(DISTINCT sum(Sales), ISO2)),1),1), ISO2),

       

      ps: ISO2 - code ISO 3166-2 for region adm