Survey123 Rating field type is String, I need Integer

Question

I've designed a Survey123 form with the online design form.  I used the "Rating" widget to allow the user to rate an item from 1-5 stars.  The resulting data is formatted as STRING, even though it only contains integer values.  I'd like to display an AVERAGE rating value from this survey on a dashboard, but with the rating field formatted as STRING that isn't possible.  Can I somehow re-cast this field as an integer (maybe in a view?) so that Dashboard can get an average from it?

jzibbell_boise · Answer

But AGOL can aggregate in Survey123 analytics, just not us in a Dashboard. Why?

jzibbell_boise · Answer

I am realizing the same thing after publishing my survey. I thought I could do a hidden field too in the web builder app, but it doesn't allow me to calculate using the rating string field. I guess I'll try to open it in Connect and publish from there without breaking my survey that is already collecting responses. This seems like a bug and should be changed.

dougbrowning · Answer

If you can make hidden fields in the web builder then you can just use a second field with a calc of int(ratingfield).  You could also use the new data expressions in Ops Dashboard to convert it then.

Hope that helps