Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

How to see a calculated column on a chart?

Avatar

Level 10

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 8

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

Avatar

Level 10

okay thank you.

Avatar

Level 3

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

Avatar

Community Advisor

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.

Avatar

Level 3

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