chart multipicklist agg by each picklist value and not concatenated set of values

  • 2
  • Idea
  • Updated 3 years ago
  • Not Planned
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb

Posted 3 years ago

  • 2
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
I'm pretty sure that's the way multipicklist data is stored.  Parsing the values into separate items would be some pretty tricky code.  When we see this sort of requirements we usually point to storing the picklist values in a reference object and building a junction object between the two so that the many to many relationship is achieved.  I know its a pain....