How to see a calculated column on a chart?

Forum|Forum|5 years ago
June 29, 2020
3 replies
745 views

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?

Best answer by skyehansen

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.

A

AdinaPi1

Level 9

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

B

BenettaPeAuthor

Level 9

okay thank you.

K

Kasey-Gagne

Level 5

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.

K

Kasey-Gagne

Level 5

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded