Map Value and Fusion Chart Challenge
Hello Everyone,
I have been currently challenged to map cell changes from a Map Value Rule to a Fusion Chart. Please see also attached screenshots to get an overview of it.
We have created an Y-and X-Axis graph in the Map Value rule which starts from 0 to 1 like 0, 0.1,0.2,... in both ways. Every value within the Map Value Rules contains a status like high, medium and low. This can be changed on the UI via dropbox. Each axis represents the result of one calculation.
If the value changes (e.g., medium to low) it should be displayed within a chart on the dashboard like a Fusion Chart. I have created a custom control which i used as a Heat Map with Javascript to display a correct chart onto the Dashboard (like the attached one).
My question is whether a connection between both rules is possible, so when a cell has changed in the Map Value this has to represent to the Heat map chart.
Any help and support is welcome.
Thanks and BR
***Updated by moderator: Lochan to mark post as question***
Thanks, this approach is working.
Hi Norman,
This is possible but not OOTB. You'll need to create a custom control to display the chart.
I would use a data page to load up the map value rule you want and use its data model to build up the dataset/data objects for your visualization.
Fusion charts heatmap: http://jsfiddle.net/fusioncharts/LsSU9/
From looking at the map value data model, you'll want to loop over the .pyTable and .pyColumnValues page lists. On the .pyColumnValues pages, the properties match up pretty well to the FusionChart attibutes for each data object.