Hi
I have a form with 8 questions with Integer answers
How do i add a calculation to another question to add all those up and divide by 8?
I want to use the average score to symbolise by
Solved! Go to Solution.
You will want to use the "Mean" function, which you can find more information on here: Math functions | ArcGIS Arcade | ArcGIS Developers
As an example, you will see I have created a calculated expression for one of my fields in field maps to be the mean of my first two questions:
Hopefully this helps, let me know if you have any questions!
Issy
Go to Styles, click the Expression button, use something like (updating it with all your fields):
Round(Average([$feature.field1,$feature.field2,$feature.field2. $feature........]),0)
Pick Types (unique symbols) for the style.
Then, click the three dots next to Title and Add Value to add the values/symbols you want.
R_
You will want to use the "Mean" function, which you can find more information on here: Math functions | ArcGIS Arcade | ArcGIS Developers
As an example, you will see I have created a calculated expression for one of my fields in field maps to be the mean of my first two questions:
Hopefully this helps, let me know if you have any questions!
Issy
Brilliant! That's worked for me.
Thankyou so much. I really appreciate your help 🙂
Go to Styles, click the Expression button, use something like (updating it with all your fields):
Round(Average([$feature.field1,$feature.field2,$feature.field2. $feature........]),0)
Pick Types (unique symbols) for the style.
Then, click the three dots next to Title and Add Value to add the values/symbols you want.
R_