howlowck Report post Posted December 5, 2011 (edited) 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 December 5, 2011 by howlowck Share this post Link to post Share on other sites
Guest Bindhu Report post Posted December 6, 2011 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 Share this post Link to post Share on other sites
howlowck Report post Posted December 6, 2011 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 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 Report post Posted December 7, 2011 (edited) 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 Edited December 7, 2011 by Bindhu Share this post Link to post Share on other sites
