Jump to content


How To Get "count" Of Items As Value?


  • Please log in to reply
5 replies to this topic

#1 h2data

h2data

    Forum Newbie

  • Members
  • 3 posts

Posted 02 March 2011 - 01:19 PM

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!

Attached Thumbnails

  • chart.png


#2 Rahul Kumar

Rahul Kumar

    Supreme Being

  • Moderators
  • 1150 posts

Posted 03 March 2011 - 09:45 AM

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.
Regards,
Rahul Kumar
Tech Lead


A byte of magic.

#3 h2data

h2data

    Forum Newbie

  • Members
  • 3 posts

Posted 07 March 2011 - 08:41 AM

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?

Attached Thumbnails

  • chart.png


#4 Rahul Kumar

Rahul Kumar

    Supreme Being

  • Moderators
  • 1150 posts

Posted 08 March 2011 - 09:36 AM

Hi ,

Could you please refer to the steps shown in the attached screenshot and let us know if this is what you needed?

Attached Thumbnails

  • Image.png

Regards,
Rahul Kumar
Tech Lead


A byte of magic.

#5 h2data

h2data

    Forum Newbie

  • Members
  • 3 posts

Posted 09 March 2011 - 02:35 PM

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!

#6 Angshu

Angshu

    Supreme Being

  • Administrators
  • 3222 posts

Posted 10 March 2011 - 05:24 AM

Hi,

Thank you very much for your appreciation.

We are glad to know that you have managed to solve your purpose.

Happy FusionCharting!Posted Image
Help us improve our documentation with your precious feedback at:

[url="http://documentation-survey.g.fusioncharts.com/"][url][url]http://documentation...sioncharts.com/[/url][/url][/url]

Best,

Angshu

[url="http://twitter.com/fusioncharts"]Follow us on @Twitter[/url]