Totals In Heatmaps

[Totals In Heatmaps]

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.

[Totals In Heatmaps]

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!

[Fusionwidgets And Asp.net]

Nevermind. I find that it's just the same as Fusion Charts

 

Thank you

[Fusionwidgets And Asp.net]

Hi, I'm just wondering if there is a way to use FusionWidget on the server much like FusionCharts.

 

If so, there is no example in the exterprise package nor on the online documentation.

Do I just use FusionCharts.dll in the project, and the same syntax in the code-behind?

 

Thank You

[Separate Data Xml And Style Xml]

Hi,

 

I'm working on a project where I would have to run a monthly job that would fetch all the data from database and put it in XML sheets. I would like to have the flexibility to change the styles of the charts without changing the job all the time.

 

So I was wondering if there is a way to have two xml files for each chart, one for the data (generated by the job) and the other for styling.

 

Thanks!