Fusion Charts can be easily and extensively used to create drill-down charts. Using the drill down functionality provided by Fusion Charts, you can easily produce charts that have “drill down” or “zoom in (data)” capabilities.
In my last blog I had explained how we can generate XML based fusion charts using COM API and .NET API. You can refer below links for the same.
Related Posts: XML based Fusion Charts using .NET API
In this blog I will explain Simple links feature of Drill Down functionality provided by Fusion Charts. This feature enables Drill-down to open simple URLs.
Let us consider the same example which we had discussed in the above blogs that we want to display the bar chart for forecast achieved in current quarter. In this example, suppose we want to open a new window with some URL when we drill down the chart. To do this, we have to pass one more attribute named as “link” in the “set” element. Below is the reference code for the same.
Code in COM API:
<set label=”October” value=”5000″ link=”n-http://www.google.co.in”/>
Code in .NET API:
XmlElement hedder = docConfig.CreateElement(“set”);
hedder.SetAttribute(“link”, “n-http://www.google.co.in”); docConfig.DocumentElement.PrependChild(hedder);
In the above code, we have to mention the URL after “n-” which we need to open after drill down.
By following above steps, when we drill down the chart it will looks like as follows.
1) Show Chart Block On Classic Dashboard
2 ) Charts On Interactive Dashboard
3) Generating a Simple Pie chart in Sage CRM using COM API
4) Re-Organization Charts
5) Historical Reports – Opportunity Closing History