Chart grouping using merged columns?

[BenettaPe]

I FINALLY successfully created a calculated column on my report. YEAH ME.

Now, when I go to the grouping area - this column is not selectable to be grouped. WHY?

Now, when I go to the chart area - this column is not presented for me to select? WHY?

So I can see the data in the column on the details tab of the report - but I can't do anything with it.

What am I missing or is this a known workfront limitation?

[AdinaPi1]

Hi Benetta, it needs to be a calculated field on the custom form in order for it to be groupable/chartable.

[BenettaPe]

okay thank you.

[Kasey-Gagne]

Is there a way I can add a grouping using a merged column in a chart view?

We have separate custom fields for Requestor First Name and Requestor Last Name that I've merged into 1 column that I'd like to use to display in a chart view of how many requests by Requestor. 

Any help is appreciated 🙂 Thank you!

[skyehansen · Accepted solution]

charts work by using real fields - not merged columns. The best way to handle this would be to create a calculated field on the form that merges the two names together and then chart using this field.

[Kasey-Gagne]

AH great idea! Thank you, I will go the calc field route 🙂