I have a library of items I would like to report on dynamically. For the sake of this exercise, I would like to show 2 items from the list:
The region in which the list item exists
The status of the list item
I am using a calculated column to determine the status.
When I attempt to graph using the web part, I am not able to select the status column as a Y value. This, I assume, is because it is not a numerical value.
Something tells me my best solution is to create a second list that will connect to the library, to provide a summary table with actual counts for each region/status, but I am not clear on the methodology to do so. When I attempted to use lookup columns, I was simply given a blank list and the ability to add one item at a time from the library.