Average between more field

490
1
Jump to solution
08-08-2022 02:59 AM
Labels (2)
GiulioMol
New Contributor II

Good morning to all and sundry, I have a question about the experience builder. 
Is it possible to do functions between multiple data from different fields? 
for example, i have a layer with set of polygons and different descriptions, i can find the sum of the total Ha in the extent of the single field, but how do i average between the sum of the Ha of that single versus another.

Thank you very much in advance

0 Kudos
1 Solution

Accepted Solutions
GiulioMol
New Contributor II

I solved basically creating a view for each field I needed. Then I took advantage of the Expression area of the Dynamic content in the Widget text, and selected the data to use in the function by selecting a specific view for each one.

For example, ((SUM({Area_Ha})*100)/(SUM({Area_Ha})))*100

When i click on first Area_ha field i selected the specific Data in the dropdown, same for second

View solution in original post

0 Kudos
1 Reply
GiulioMol
New Contributor II

I solved basically creating a view for each field I needed. Then I took advantage of the Expression area of the Dynamic content in the Widget text, and selected the data to use in the function by selecting a specific view for each one.

For example, ((SUM({Area_Ha})*100)/(SUM({Area_Ha})))*100

When i click on first Area_ha field i selected the specific Data in the dropdown, same for second

0 Kudos