I have a list that is used for keeping records of taskings. The list contains a calculated column that creates a string to categorize the list items based off a few other fields and date. I would like to display a bar chart that can group the like items and display a count but I'm having difficulty displaying the data. To simplify I have data similar to this:
Title CalculatedColumn foo1 "2014 Q1" foo2 "2014 Q1" foo3 "2014 Q2" bar1 "2014 Q1" bar2 "2013 Q4"
Now I want to display a bar chart showing:
2013 Q4 - 1 item 2014 Q1 - 3 items 2014 Q2 - 1 item
How do I filter the data from the list to group and count like items? Do I need Visual Studio to perform that kind of calculation or can it be done with SharePoint Designer?