Creating chart using custom field

[gSoe]

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? 

[Richard_Le_ · Accepted solution]

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.