Dashboard charts using custom field calculation

I’m using a select field for a survey from to capture 1-5 and now need to add other custom field results together for a chart - but as they are not Number fields it seems impossible - any help here would be appreciated

2 posts were merged into an existing topic: Custom Fields - Detect dropdown values as numeric values in calculations