How to make getFacetedUniqueValues() return correct number of unique values in column which each cell contains multiple value?

[cometyang]

I customize the column and make it can display multiple values in each cell. However, I find the getFacedUniqueValues() does not work for cell contain array of strings. How can I make it calcuate the correct number of unique string?

For example:

| Column A |.
|. [a, b]|
| [a]. |
|. [b]. |
|. [a, b] |

I expected the getFacedUniqueValues() return a Map with (a,3), (b,3). Instead it didn't behave this way. How should I solve this problem?

[cesardelacruz]

Unfortunately getFacetedUniqueValues() currently does not work for columns containing an array of strings.

You can work around this issue as follows to get the correct value:

const facets = column?.getFacetedUniqueValues();
// Custom facets if keys is array then sum the equal value and remove duplicate
const customFacets = new Map()
for (const [key, value] of facets as any) {
   if (Array.isArray(key)) {
      for (const k of key) {
         const prevValue = customFacets.get(k) || 0;
         customFacets.set(k, prevValue + value);
      }
   } else {
      const prevValue = customFacets.get(key) || 0;
      customFacets.set(key, prevValue + value);
   }
}
console.log(customFacets);

I hope I was helpful :)

[zacBkh]

Thank you so much, it works out of the box!