Tracking "Support Type" Across Events
I am attempting to create a dashboard that pulls from reports/sheets I've made that relate to event support for my organization.
There are three types of support that my team offers for events. They are not mutually exclusive. The names of each support type are "Streaming," "Podium Support," and "Photography."
On the form side, a requestor of event support can select any or all of these three support types (represented by a column called "Event Support Type," a dropdown list column in the intake sheet).
Now, when it comes to adding data to reports/dashboards, Smartsheet doesn't like cells that contain multiple values, so I've created helper columns (checkbox type), 1 for each support type. If an event support type is selected in "Event Support Type," a formula causes a box to be checked in the corresponding column of that type.
I've tried building a single report with multiple groups/summaries. I've tried building three separate reports (one for each type of support requestors can request). I'm struggling and could use some insight.
Because one event (represented by an individual row) may include requests for anywhere from 1-3 types of support, and because I can seemingly only choose one data source for a chart, I'm not sure how to weave all of this into a single chart widget within my dashboard that shows the number of requests for each type of support (think pie chart with 3 pieces showing number of each support type, similar to the one below - I faked this one based on a different metric that was easier to figure out, but this is what I'm hoping to accomplish).
What I would ultimately like to accomplish in a dashboard is a breakdown of how many times each type of support was requested. With the path I've used to get this far, is that even possible? Maybe counting only the true/checked values of the individual helper columns in some way? Thanks!