Expand my Community achievements bar.

SOLVED

Creating chart using custom field

Avatar

Level 1

Is it possible to create chart using custom column?

 

I created a calculated column using text mode to calculate efficiency. I want to create a chart for average efficiency across my team members which I want to include in the dashboard. Currently, I am seeing that only pre-made columns can be used for charting. Is there a way to work around this problem? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

The only way to achieve this would be to replicate the calculation from your column into a custom field and attach it to the objects you report on. 

 

It's not possible to chart based on values created in a calculated column as these values don't exist in the database (they are just calculated on screen when you load the report).

 

Best Regards,

Rich. 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

 

The only way to achieve this would be to replicate the calculation from your column into a custom field and attach it to the objects you report on. 

 

It's not possible to chart based on values created in a calculated column as these values don't exist in the database (they are just calculated on screen when you load the report).

 

Best Regards,

Rich.