Creating a chart for a multi-select field using calc fields I have a multi-select field on all of our custom forms to select the company(s) the project applies to. The end goal is to have ONE pie chart that shows how many projects for each company so that we can allocate resource costs to those companies accordingly. I've tried creating separate calc fields for each company that populates a 1 or a 0, which functions as it should. However, I cannot seem to figure out how I can now use these values in 1 chart... Is there a better way to handle this or am I out of luck and stuck exporting reports to excel to do the calculations? Field 1:IF({DE:Company}="CompanyA", 1, 0) Field 2:IF({DE:Company}="CompanyB", 1, 0) Field 3:IF({DE:Company}="CompanyC", 1, 0) Things to note:I'm only showing 3 here as an example, however we have ~20 companies in the drop downCreating separate projects per company to avoid the multi-select field is not an option
