Sign in to follow this  
howlowck

Totals In Heatmaps

Recommended Posts

I'm using heatmaps, and I'm wondering is there a way to have a rollup in either the x or y direction?

 

If not, I can sum it up in the logic before PowerCharts, but then is there a way to exclude these cells from the color coding in heatmaps?

 

Thanks!

Edited by howlowck

Share this post


Link to post
Share on other sites
Guest Bindhu

Hi,

 

The "mapByCategory" attribute lets you group cells based on category.

 

You can use this attribute to differentiate the 'sum' cell and the rest.

 

Please find attached screenshot for a sample data, with the 'sum' displayed in the last column.

 

This is a work-around, as PowerCharts does not support the summing up feature.

 

The sample XML is,

 

<chart Caption='PR Visibility (articles)' xAxisName='Week Days' yAxisName='Companies' mapByCategory='1'>

 

<rows>

<row id='Yahoo'/>

<row id='Google'/>

<row id='Microsoft'/>

<row id='Symantec'/>

<row id='AOL'/>

</rows>

 

<columns>

<column id='MON'/>

<column id='TUE'/>

<column id='WED'/>

<column id='THU'/>

<column id='FRI'/>

<column id='sum'/>

</columns>

 

<colorRange>

<color code ='CCCCCC' label='total'/>

<color code ='CCCC99' label='data'/>

</colorRange>

 

<dataset>

<set rowId='Google' columnId='Mon' value='68' colorRangeLabel='data'/>

<set rowId='Google' columnId='Tue' value='35' colorRangeLabel='data'/>

<set rowId='Google' columnId='Wed' value='95' colorRangeLabel='data'/>

<set rowId='Google' columnId='Thu' value='17' colorRangeLabel='data'/>

<set rowId='Google' columnId='Fri' value='55' colorRangeLabel='data'/>

<set rowId='Google' columnId='sum' value='270' colorRangeLabel='total' />

 

<set rowId='Yahoo' columnId='Mon' value='0'colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Tue' value='71' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Wed' value='70' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Thu' value='63' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Fri' value='79' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='sum' value='362' colorRangeLabel='total'/>

 

<set rowId='Microsoft' columnId='Mon' value='98' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Tue' value='48' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Wed' value='31' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Thu' value='79' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Fri' value='39' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='sum' value='295' colorRangeLabel='total'/>

 

<set rowId='Symantec' columnId='Mon' value='89' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Tue' value='68' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Wed' value='90' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Thu' value='19' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Fri' value='69' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='sum' value='335' colorRangeLabel='total'/>

 

<set rowId='AOL' columnId='Mon' value='58' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Tue' value='27' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Wed' value='100' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Thu' value='70' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Fri' value='89' colorRangeLabel='data'/>

<set rowId='AOL' columnId='sum' value='344' colorRangeLabel='total'/>

</dataset>

</chart>

 

Hope this helps !!

 

Happy FusionCharting :D

Share this post


Link to post
Share on other sites

Hi,

 

The "mapByCategory" attribute lets you group cells based on category.

 

You can use this attribute to differentiate the 'sum' cell and the rest.

 

Please find attached screenshot for a sample data, with the 'sum' displayed in the last column.

 

This is a work-around, as PowerCharts does not support the summing up feature.

 

The sample XML is,

 

<chart Caption='PR Visibility (articles)' xAxisName='Week Days' yAxisName='Companies' mapByCategory='1'>

 

<rows>

<row id='Yahoo'/>

<row id='Google'/>

<row id='Microsoft'/>

<row id='Symantec'/>

<row id='AOL'/>

</rows>

 

<columns>

<column id='MON'/>

<column id='TUE'/>

<column id='WED'/>

<column id='THU'/>

<column id='FRI'/>

<column id='sum'/>

</columns>

 

<colorRange>

<color code ='CCCCCC' label='total'/>

<color code ='CCCC99' label='data'/>

</colorRange>

 

<dataset>

<set rowId='Google' columnId='Mon' value='68' colorRangeLabel='data'/>

<set rowId='Google' columnId='Tue' value='35' colorRangeLabel='data'/>

<set rowId='Google' columnId='Wed' value='95' colorRangeLabel='data'/>

<set rowId='Google' columnId='Thu' value='17' colorRangeLabel='data'/>

<set rowId='Google' columnId='Fri' value='55' colorRangeLabel='data'/>

<set rowId='Google' columnId='sum' value='270' colorRangeLabel='total' />

 

<set rowId='Yahoo' columnId='Mon' value='0'colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Tue' value='71' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Wed' value='70' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Thu' value='63' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='Fri' value='79' colorRangeLabel='data'/>

<set rowId='Yahoo' columnId='sum' value='362' colorRangeLabel='total'/>

 

<set rowId='Microsoft' columnId='Mon' value='98' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Tue' value='48' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Wed' value='31' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Thu' value='79' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='Fri' value='39' colorRangeLabel='data'/>

<set rowId='Microsoft' columnId='sum' value='295' colorRangeLabel='total'/>

 

<set rowId='Symantec' columnId='Mon' value='89' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Tue' value='68' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Wed' value='90' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Thu' value='19' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='Fri' value='69' colorRangeLabel='data'/>

<set rowId='Symantec' columnId='sum' value='335' colorRangeLabel='total'/>

 

<set rowId='AOL' columnId='Mon' value='58' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Tue' value='27' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Wed' value='100' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Thu' value='70' colorRangeLabel='data'/>

<set rowId='AOL' columnId='Fri' value='89' colorRangeLabel='data'/>

<set rowId='AOL' columnId='sum' value='344' colorRangeLabel='total'/>

</dataset>

</chart>

 

Hope this helps !!

 

Happy FusionCharting :D

 

Thank you very much for your response.

 

However, please correct me if I'm wrong, this would mean that the data section would lose the gradient which is the reason for heat map in the first place.

Share this post


Link to post
Share on other sites
Guest Bindhu

Hi,

 

Thank you for your reply.

 

Well, that was one of the work-rounds to include the "Sum" column.

 

If you want to the gradient feature of HeatMaps, then you will have to include the "Sum" column values in the color range, as there is no attribute to support your requirement of excluding the "Sum" from the color coding of HeatMaps.

 

Here is the sample XML,

 

<chart Caption='PR Visibility (articles)' xAxisName='Week Days' yAxisName='Companies' >

 

<rows>

<row id='Yahoo'/>

<row id='Google'/>

<row id='Microsoft'/>

<row id='Symantec'/>

<row id='AOL'/>

</rows>

 

<columns>

<column id='MON'/>

<column id='TUE'/>

<column id='WED'/>

<column id='THU'/>

<column id='FRI'/>

<column id='Sum'/>

</columns>

 

<dataset>

<set rowId='Google' columnId='Mon' value='68' />

<set rowId='Google' columnId='Tue' value='35' />

<set rowId='Google' columnId='Wed' value='95' />

<set rowId='Google' columnId='Thu' value='17' />

<set rowId='Google' columnId='Fri' value='55' />

<set rowId='Google' columnId='Sum' value='270' />

 

<set rowId='Yahoo' columnId='Mon' value='0'/>

<set rowId='Yahoo' columnId='Tue' value='71' />

<set rowId='Yahoo' columnId='Wed' value='70' />

<set rowId='Yahoo' columnId='Thu' value='63' />

<set rowId='Yahoo' columnId='Fri' value='79' />

<set rowId='Yahoo' columnId='Sum' value='362' />

 

<set rowId='Microsoft' columnId='Mon' value='98' />

<set rowId='Microsoft' columnId='Tue' value='48' />

<set rowId='Microsoft' columnId='Wed' value='31' />

<set rowId='Microsoft' columnId='Thu' value='79' />

<set rowId='Microsoft' columnId='Fri' value='39' />

<set rowId='Microsoft' columnId='Sum' value='295' />

 

<set rowId='Symantec' columnId='Mon' value='89' />

<set rowId='Symantec' columnId='Tue' value='68' />

<set rowId='Symantec' columnId='Wed' value='90' />

<set rowId='Symantec' columnId='Thu' value='19' />

<set rowId='Symantec' columnId='Fri' value='69' />

<set rowId='Symantec' columnId='Sum' value='335' />

 

<set rowId='AOL' columnId='Mon' value='58' />

<set rowId='AOL' columnId='Tue' value='27' />

<set rowId='AOL' columnId='Wed' value='100' />

<set rowId='AOL' columnId='Thu' value='70' />

<set rowId='AOL' columnId='Fri' value='89' />

<set rowId='AOL' columnId='Sum' value='344' />

</dataset>

 

<colorRange gradient='1' minValue='0' code='B63300' startLabel='Data Range Start' endLabel="Sum">

 

<color code ='FFCC00' maxValue='200' label='End of Data Values'/>

<color code ='006384' maxValue='400' />

 

</colorRange>

 

</chart>

 

Also, please find attached the screen shot of the HeatMap rendered using the above sample XML.

 

Hope this helps !!

 

Happy FusionCharting :D

post-23884-0-88478600-1323228324_thumb.png

Edited by Bindhu

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this