Hi Justin,
Thanks for the response, I was under the impression you couldn't chart on these fields. IS it possible to do a Calculated Field, off of a previous calculated field? Or would that create a circular/chained reference problem for the reporting?
The reason I ask, is because for the report/chart I'd like to finally display, I'd like to aggregate the percentages of the muli-select fields to a single Percentage calculation against "IF" the check boxes are selected per project. For Example. Options A, B, C, D, E exist to be selected. I would like to capture IF selected option, then count + 1. Then take the Sum of A, B, C, D, E selections on each individual project, and calculate the percentage of projects in the portfolio that have each option selected, as well as list a percentage of projects that have NO listed option selected. This is where I get stuck...I'm not sure how to aggregate the calculated field percentages when you have projects with multiple selections chosen, for example Project 1: A, Project 2: A+C, Project 3: B+C, etc.). every KIND of selection option shows up as a separate percentage when I use the single calculated field in the chart. I'm not sure how to get the chart to aggregate those percentages in a single report.
Or if that is even possible, and instead you'd have to use some sort of dashboard with other calculations/calculated fields applied, or an extremely advanced TEXT based Grouping by calculated field(s) (which doesn't seem possible to then ALSO CHART) using the calculated field based on the documentation. It seems to be a catch 22. Or maybe there's a better way to achieve the end goal with how I "collect the data" for reporting initially, I'm all ears. Not sure, yet which is the best way to solve the mystery. Sorry for the rambling.
Patrick Yarnell Hylant