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

149
0
07-17-2020 02:47 PM
Soper_Chuck
New Contributor III

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

Tags (1)
0 Kudos
0 Replies