Forum Discussion

kmizuno's avatar
kmizuno
Qrew Member
12 minutes ago

How to group a report by individual values in a Multi-select Text field?

I have a Multi-select Text field on my Projects table called Project Products. A project can have multiple products, for example:

Product A; Product B; Product C

I’m trying to build a report that groups/counts by each individual product, but when I group by the multi-select field, Quickbase groups by the entire combination of selected values instead.

For example, I’m getting groups like:

Product A; Product B

Product A

Product B; Product C

Instead, I want the report to display:

Product A — 2 projects

Product B — 2 projects

Product C — 1 project

Is there a way to “explode” or separate the values from a Multi-select Text field so each individual product can be grouped and counted within one report?

No RepliesBe the first to reply