h2data Report post Posted March 2, 2011 I have a task-list in my Sharepoint 2010 Foundation that contains a number of tasks that have the usual status values (not started, in progress, completed...) How do I configure the chart to have it pick up the number of tasks in each status? Since theres no actual value in the data that says 55 tasks in state: not started I can't get that data. Will there be a "view count" option in the upcoming releases? Looking forward working with the product! Share this post Link to post Share on other sites
Rahul Kumar Report post Posted March 3, 2011 Hi, To set the series options, please go to "Series Customization" tab -> X-Axis tab is used to set data labels field, and "Series X" tab is used to set the data value field for that particular Series. So in you case select Value Column: "Status" in "Series 1" tab. Hope this helps. Share this post Link to post Share on other sites
h2data Report post Posted March 7, 2011 Hi! I'm afraid that this doesn't solve my problem since there's no actual numeric value in the status row to display. I need to count the number if each status and display the result of the count as a value. In the attached image I have five rows of data and I want to show that there are 2 items in Compete, 1 item in Not Started and so on. Is there a function within the webpart to make this count or do I have to build a logic in between the data source and FusionCharts that calculates the count and write it in "clear text" in a separate column for FusionCharts to read from? Share this post Link to post Share on other sites
Rahul Kumar Report post Posted March 8, 2011 Hi , Could you please refer to the steps shown in the attached screenshot and let us know if this is what you needed? Share this post Link to post Share on other sites
h2data Report post Posted March 9, 2011 Hi , Could you please refer to the steps shown in the attached screenshot and let us know if this is what you needed? This was exactly what I was looking for! The ability to count the number of items. Thank you so much! Share this post Link to post Share on other sites
Guest Angie Report post Posted March 10, 2011 Hi, Thank you very much for your appreciation. We are glad to know that you have managed to solve your purpose. Happy FusionCharting! Share this post Link to post Share on other sites