Is there a good way to show the # of records where each option from a multi-select text field is selected WITHOUT showing every single unique combinations. For example, if Option A is selected on one record, Option A AND Option B would NOT be a separate bar on the bar chart, it would just show the actual choices in the field.
Qrew LegendSo there is a low tech solution and a high tech solution. The stupid simple low tech solution is simply to set the multi select field as a Dynamic Filter, and then apply the dynamic filters, one by one to see the results. The dynamic filter will offer the choices based on the individual elements of the multi select field and not all the crazy combinations.
But if you really did want to visualize a report or chart at a glance without having to use the dynamic filters, then we get into more high-tech solutions.
You would have to have a Pipeline which would create the required children based on what was selected in the multi select text field. So if the multi select field selected Tom, **bleep** and Harry, then the pipeline would run and delete all the children and remake just those children for Tom, **bleep** and Harry. Then you would run your chart off that child table.
I can help you with the conceptual set up of that pipeline if you want, but maybe the low tech Dynamic Filters solution is good enough for you for now.
