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:
<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