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
Solved! Go to Solution.
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
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