Select to view content in your preferred language

Calculated Expression help please

447
3
Jump to solution
06-04-2024 07:19 AM
LauraBoagey1
Emerging Contributor

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

0 Kudos
2 Solutions

Accepted Solutions
IssyAmis
Esri Contributor

Hi @LauraBoagey1 

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:

IssyAmis_0-1717515084493.png

IssyAmis_1-1717515094716.png

Hopefully this helps, let me know if you have any questions!

Issy

View solution in original post

RhettZufelt
MVP Notable Contributor

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.

RhettZufelt_0-1717515306681.png

Then, click the three dots next to Title and Add Value to add the values/symbols you want.

RhettZufelt_1-1717515345509.png

R_

 

View solution in original post

0 Kudos
3 Replies
IssyAmis
Esri Contributor

Hi @LauraBoagey1 

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:

IssyAmis_0-1717515084493.png

IssyAmis_1-1717515094716.png

Hopefully this helps, let me know if you have any questions!

Issy

LauraBoagey1
Emerging Contributor

Brilliant! That's worked for me.
Thankyou so much. I really appreciate your help 🙂

RhettZufelt
MVP Notable Contributor

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.

RhettZufelt_0-1717515306681.png

Then, click the three dots next to Title and Add Value to add the values/symbols you want.

RhettZufelt_1-1717515345509.png

R_

 

0 Kudos