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
