Chart Enhancements (Revision #36)

New Function Series 'Average': The new function, Average, sums all values in a series and divides that sum by the total number of rows/samples.  This value is then plotted as a horizontal line. This is useful for visually comparing a series' data points against the average for those data points. 

Function-Series Average

New Chart Type 'Map': The new chart type, Map, presents a flat world map with country outlines. Chart Options for Map include the ability to show country details (population, currency, and area in square units) and a low-resolution satellite view background image. To use the Map Chart Type, ensure that your query contains a column with country values. We support country names & country codes as specified in the ISO2, ISO3, GMI & FIPS specifications. For convenience, a reference guide is here.

Creating a Map Chart Type: Once you have a resultset with country values, go to your charts region and choose your Chart Type as Map, choose one category field (containing country name) and one series field (containing the data value). For each distinct country in the resultset, the series values are summed.  The map is then color coded to highlight only the countries found in the resultset. As you hover your mouse over a highlighted country, a tooltip is displayed with the summed value for that country.

For example, if your resultset contains these rows:

then your Map will have 2 highlighted countries and the values displayed for France and United States will be 600 and 900, respectively.

You can also specify your own color-coding scheme for map highlighting. To do this, go to the Chart Options menu. For the Map Ranges parameter, specify "0,700,1000" then 2 ranges are created:

[0, 700) ==> from 0 inclusive to 700 exclusive
[700, 1000] ==> from 700 inclusive to 1000 inclusive

You can then specify the highlight color for each range by filling in the Map Range Colors attribute. For our example, "green,blue". So in our map, France will be highlighted in green and United States in blue.

Map Chart	Map Chart Options