I am working in SharePoint 2010. I need to make a chart to represent how many projects we have from each division. We have a SharePoint list of our projects with a choice column of all the divisions.
What I need is a way to count how many of each choice there is and put this into another webpart/list that the chart web part can read in to display as a pie chart. I understand they could be counted manually but I'd like to automate it if possible so up to date information is always present.
If I were to do a calculated column that outputs a 1, 100, 10000, 1000000,... for the row based on division, I could then do some funky math with mods and remainders on the total of that to figure out how many of each but I need to know if there is any way to access that total item. Would javascript/jQuery be able to find that number?
The source code for the area that holds the column total with the closest searchable class name looks like:
<td class="ms-vb2">
<nobr>
<b>Sum= 102,040,102</b>
</nobr>
</td>
Are <nobr>
tags very rare in SharePoint sites? Could I do a search for all ms-vb2 and would I have a high chance of only finding one ms-vb2 with a <nobr>
tag in it? Any ways to finish off this idea or any better ideas would be great. Thanks in advance for any advice.