How to display Series Chart with age range from a question in Survey123?

Soper_Chuck — Fri, 17 Jul 2020 21:47:24 GMT

I have a dashboard that shows the results of a Survey123 form. One question is Age? with an integer result. What is the best way to display a Series Chart with different age ranges. For example, for simplicity, 0-9, 10-14, 15-18, 19-24, and 25+.

I could add a new "ageRange" field in the survey for with the following calculation:

if(${age} <= 9,1,if(${age} >= 10 and ${age} <= 14,2,if(${age} >= 15 and ${age} <= 18,3,if(${age} >= 19 and ${age} <= 19,4,5))))

Then, the dashboard would use integer values: 1: 0-9, 2:10-14, 3: 15-18, 4: 19-24, and 5: 25+.

There must be a better way! Does anyone have any suggestions? Should I be asking this question in a different forum?

Thanks,

Chuck

topic How to display Series Chart with age range from a question in Survey123? in ArcGIS Dashboards Questions

How to display Series Chart with age range from a question in Survey123?