Monday, 15 April 2013

Heatmap Chart

The following XML is used to generate Heatmap Chart and it requires HeatMap.swf file in order to generate the output.

<chart Caption='Monthly % conversion rates from different marketing mediums' subCaption='(Visits to Downloads)'>
        <rows>
            <row id='Search'/>
            <row id='Directories'/>
            <row id='Newsletter'/>
            <row id='External Articles'/>
            <row id='Paid Reviews'/>
            <row id='Social Media'/>
        </rows>
        <columns>
               <column id='Jan' />
               <column id='Feb' />
               <column id='Mar' />
               <column id='Apr' />
               <column id='May' />
               <column id='Jun' />
               <column id='Jul' />
               <column id='Aug' />
               <column id='Sep' />
               <column id='Oct' />
               <column id='Nov' />
               <column id='Dec' />
        </columns>
    <dataset>
        <set rowId='Search' columnId='Jan' value='21'/>
        <set rowId='Search' columnId='Feb' value='24'/>
        <set rowId='Search' columnId='Mar' value='25'/>
        <set rowId='Search' columnId='Apr' value='27'/>
        <set rowId='Search' columnId='May' value='32'/>
        <set rowId='Search' columnId='Jun' value='34'/>
        <set rowId='Search' columnId='Jul' value='35'/>
        <set rowId='Search' columnId='Aug' value='36'/>
        <set rowId='Search' columnId='Sep' value='40'/>
        <set rowId='Search' columnId='Oct' value='38'/>
        <set rowId='Search' columnId='Nov' value='36'/>
        <set rowId='Search' columnId='Dec' value='34'/>
        <set rowId='Directories' columnId='Jan' value='31'/>
        <set rowId='Directories' columnId='Feb' value='32'/>
        <set rowId='Directories' columnId='Mar' value='29'/>
        <set rowId='Directories' columnId='Apr' value='27'/>
        <set rowId='Directories' columnId='May' value='35'/>
        <set rowId='Directories' columnId='Jun' value='36'/>
        <set rowId='Directories' columnId='Jul' value='36'/>
        <set rowId='Directories' columnId='Aug' value='38'/>
        <set rowId='Directories' columnId='Sep' value='35'/>
        <set rowId='Directories' columnId='Oct' value='34'/>
        <set rowId='Directories' columnId='Nov' value='36'/>
        <set rowId='Directories' columnId='Dec' value='32'/>
        <set rowId='Newsletter' columnId='Jan' value='42'/>
        <set rowId='Newsletter' columnId='Feb' value='40'/>
        <set rowId='Newsletter' columnId='Mar' value='39'/>
        <set rowId='Newsletter' columnId='Apr' value='45'/>
        <set rowId='Newsletter' columnId='May' value='45'/>
        <set rowId='Newsletter' columnId='Jun' value='48'/>
        <set rowId='Newsletter' columnId='Jul' value='59'/>
        <set rowId='Newsletter' columnId='Aug' value='57'/>
        <set rowId='Newsletter' columnId='Sep' value='49'/>
        <set rowId='Newsletter' columnId='Oct' value='50'/>
        <set rowId='Newsletter' columnId='Nov' value='46'/>
        <set rowId='Newsletter' columnId='Dec' value='41'/>
        <set rowId='Social Media' columnId='Jan' value='13'/>
        <set rowId='Social Media' columnId='Feb' value='10'/>
        <set rowId='Social Media' columnId='Mar' value='12'/>
        <set rowId='Social Media' columnId='Apr' value='11'/>
        <set rowId='Social Media' columnId='May' value='10'/>
        <set rowId='Social Media' columnId='Jun' value='14'/>
        <set rowId='Social Media' columnId='Jul' value='19'/>
        <set rowId='Social Media' columnId='Aug' value='13'/>
        <set rowId='Social Media' columnId='Sep' value='12'/>
        <set rowId='Social Media' columnId='Oct' value='11'/>
        <set rowId='Social Media' columnId='Nov' value='9'/>
        <set rowId='Social Media' columnId='Dec' value='5'/>
        <set rowId='External Articles' columnId='Jan' value='31'/>
        <set rowId='External Articles' columnId='Feb' value='35'/>
        <set rowId='External Articles' columnId='Mar' value='36'/>
        <set rowId='External Articles' columnId='Apr' value='37'/>
        <set rowId='External Articles' columnId='May' value='37'/>
        <set rowId='External Articles' columnId='Jun' value='35'/>
        <set rowId='External Articles' columnId='Jul' value='36'/>
        <set rowId='External Articles' columnId='Aug' value='40'/>
        <set rowId='External Articles' columnId='Sep' value='35'/>
        <set rowId='External Articles' columnId='Oct' value='36'/>
        <set rowId='External Articles' columnId='Nov' value='33'/>
        <set rowId='External Articles' columnId='Dec' value='28'/>
        <set rowId='Paid Reviews' columnId='Jan' value='11'/>
        <set rowId='Paid Reviews' columnId='Feb' value='9'/>
        <set rowId='Paid Reviews' columnId='Mar' value='13'/>
        <set rowId='Paid Reviews' columnId='Apr' value='12'/>
        <set rowId='Paid Reviews' columnId='May' value='14'/>
        <set rowId='Paid Reviews' columnId='Jun' value='13'/>
        <set rowId='Paid Reviews' columnId='Jul' value='13'/>
        <set rowId='Paid Reviews' columnId='Aug' value='15'/>
        <set rowId='Paid Reviews' columnId='Sep' value='16'/>
        <set rowId='Paid Reviews' columnId='Oct' value='13'/>
        <set rowId='Paid Reviews' columnId='Nov' value='14'/>
        <set rowId='Paid Reviews' columnId='Dec' value='11'/>
   </dataset>
<!--We need only 2 colors for this legend - so we start with the green. have no color for the first color range and end with the red -->
    <colorRange gradient='1' minValue='0' code='CC0000' startlabel='Poor' endLabel="Excellent">
        <color maxValue='20' code='FBC860' label='Average'/>
        <color maxValue='50' code='81A749' label='Good'/>
        <color code='278127' maxValue='100'/>
     </colorRange>
</chart>


Output:



No comments:

Post a Comment