Can someone tell me if the following is possible without any coding or purchasing any 3rd party add-ons..
I have a form designed in InfoPath 2010. One of the fields is called 'Status' and its promoted. Everything works fine and there are no issues with submitting data. We want to use the Charting web part that comes with SharePoint 2010 but it only lets you select fields/columns that are numeric. Our Status field is not numeric.
The status field that I have in the form is a drop down and lets say it has the following values: Not Started, In Progress, Completed, Cancelled. We want to look at all the entries and get a count for each of those options so that it can be displayed in a SharePoint chart. Is this possible?