Queries regarding Save as Image and Grouping

[Shilpa]

I have downloaded the evaluation version of Fusion Chart 3 and am trying to incorporate it in a sharepoint site.

1. I have included all the necessary

[Guest Basundhara Ghosal]

Hi Shilpa,

Welcome to FusionCharts forum.

Could you please let us know whether you are using server-side export method or client-side export method?

[Shilpa]

Hello Basundhara,

Thanks for your response.

Actualy I am now able to save the image in JPEG/PDF/PNG formats.The problem was with the swf file locations reference.I previously had hardcoded the layouts folder location in my code as "C:Program Files....LayoutsFusion ChartsFCExporter.swf".Later I changed this location as "http:servername_layoutsFusion ChartsFCExportedr.swf". and now am able to save the image in all three formats.

I currently need help in generating a graph with multiple grouping from the following data

ID	Status	Priority	Year
1	Not Started	high	2008
2	Not Started	medium	2008
3	Testing	High	2008
4	In Progress	High	2008
5	Testing	Medium	2008
6	Not Started	Low	2008
7	Not Started	Low	2008
8	Testing	High	2008
9	Testing	High	2008
10	In Progress	Medium	2009
11	Testing	Medium	2009
12	Not Started	Low	2009
13	Not Started	Low	2009
14	Testing	High	2009
15	Testing	High	2009
16	In Progress	Medium	2009

With the above data, I am now able to group by Status and Year column.i.e. I am showing the status on X Axis, 'Year' coulmn as series and display the count on Y Axis

In the above graph I need to further display the Priority count for each status.(For e.g. Out of 12 NotStarted items in the year 2008- the first blue bar in the above graph, 6 with High priority, 4 with Medium priority and 2 with Low priority).How to depict this in the graph?

Thanks

Shilpa

[Guest Basundhara Ghosal]

Hi Shilpa,

In the above graph I need to further display the Priority count for each status.(For e.g. Out of 12 NotStarted items in the year 2008- the first blue bar in the above graph, 6 with High priority, 4 with Medium priority and 2 with Low priority).How to depict this in the graph?

You can try either of the two ways for the same.

1) Please try adding one more <dataset> element to the chart that you are using presently.

2) Please try using the 'MSColumnLine3D.swf' file of the FusionCharts pack for the same.

Hope this helps.

[Shilpa]

Hi Basundhara,

Thanks for the response. I tried adding the dataseries, But still i couldnt group by year, status and then by priority.Actually I need to create the graph with the data I posted yesterday as shown below.

It would be great if you can let me know how to build the XML to generate the above graph if I have the grouped data as follows:

Year	Status	Priority	Count
2008	Not Started	Low	10
2008	Not Started	Medium	15
2008	Not Started	High	5
2008	Completed	Low	7
2008	Completed	Medium	9
2008	Completed	High	14
2009	Not Started	Low	8
2009	Not Started	Medium	13
2009	Not Started	High	9
2009	Completed	Low	6
2009	Completed	Medium	12
2009	Completed	High	10

Thanks,

Shilpa

[Guest Basundhara Ghosal]

Hi Shilpa,

Could you please try using the "MSStackedColumn2D.swf " file for the same?

I hope this helps.

[Guest Rajroop]

Hey Shilpa,

 

We proudly announce the release of FusionCharts for SharePoint in beta. FusionCharts for SharePoint helps you create interactive & data-driven charts in SharePoint, without having to write a line of code. The charts are created using a wizard and can connect to various data sources such as SharePoint Lists, CSV, MS SQL, Oracle, Excel & BDC. You can add drill-down and export capabilities to each chart and configure both cosmetic and functional aspects.

 

 

You can download the fully-functional version from www.fusioncharts.com/sharepoint - we would love to have your feedback on this.

 

Please post your suggestions and any bugs as replies to the forum thread at:

FusionCharts for SharePoint beta impression