Workfront

CBuckwal · 4/20/25

I have a couple multi-select fields that I need to create reports for. I found this documentation- https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/cha... which notes that "Rather than building a chart using a multi-select custom field, we recommend that you create separate fields for each option of a multi-select custom field." This may be a good option for the reporting that I need, but I'm not sure how this set up for a multi-select field would look in the request form. The only thing I came up with was to have the multi select field as a separate custom form section and the multi-select field selections show in the custom form section, example shown below:

This would not be very user intuitive in the custom form, so I'm wondering if anyone has any other ideas on this multi-select field options set up as separate custom fields. Thanks

.

Sven-iX · 4/22/25

Like I said Im not sure this fits your use case but whether you create one field per the docs or multiple:

You only show the multiselect to users.

You "hide" the calc'd fields in an admin only section. The calc'd fields will be available for reporting.

View solution in original post

Sven-iX · 4/21/25

Hi @CBuckwal
a little further in the doc it states

You cannot build a chart in a report by referencing a multi-select custom field. Instead, you can create a calculated field that records the values of the multi-select custom field on a given object and group by the calculated field..

So the custom form UI would still have the multi-select.

The issue is that you can only chart on a grouped value and in order to group it it needs to be a single value.

The approach documented means that the calculated field has a string representation of the selection, e.g. value1, value4, value 6. So you can chart the grouped selections

Another approach is to create a calculated field for each selection, and you can then chart the individual selections, eg

"valueAselected" = IF( CONTAINS( {DE:My multiselect}, "value A"), "X", "" )

"valueBselected" = IF( CONTAINS( {DE:My multiselect}, "value B"), "X", "" )

CBuckwal · 4/22/25

Thanks for the explanation and text mode for the calculated field for each multiselect option. If I use the calculated field for each selection option, how can that be displayed in a custom form? As a separate section for the multiselect field question and the multiselect custom field selections shown in the same section? I have a screenshot of this in my original question. It looks very strange, so I'm wondering if there's another way to show the multiselect custom fields.