Multi-selection in custom forms - how do we report on this?

[KristinRa]

When using a custom form that allows for multi-select, how do we best report on this? We would like to accomodate when there is more than one of the following and include in pie chart data: company; stakeholder, service line

[MelindaLa1]

Workfront doesn't let you chart/group on multi-select elements. My usual workaround is to create a calculated field called Calculated FieldName with the Calculation: IF(CONTAINS(", ",FieldName),"Multiple",FieldName) So if there is a comma (ie more then one value), call it multiple, else just the single value from the checkbox. This can then be used to group and chart. Melinda Layten mlayten@gmail.com Independent Workfront Consultant