Latest Contributions by FedericoRiet_Sapriza

‎01-11-2021

Hi I'm trying to calculate the number of months between dates, but I don't get the correct answer I try with decimal and epoch time This is the answer is get in Survey123, shouldn't be 24 months? Thanks in advance for your help. Cheers, Federico @IsmaelChivite @JamesTedrick

‎01-05-2021

Hi I'm trying to make a serial chart in Dashboard which includes mean and the standard deviation as the image I attached, is this possible? The mean has already been estimated from Survey123. Thanks for the help and ideas. Cheers, Federico @VivekMalleshappa

‎12-07-2020

Thanks @DougBrowning and @Jim-Moore for your input and help, you guys rock!!!

‎12-07-2020

Dear @DougBrowning and @Jim-Moore thanks so much for your input and help. I uploaded the XLSForm you send and works fine; however, if I want to hide these calculations from the form e.i. Value, Sum of Values, Count of Repeat (see image below, red arrow) the calculation goes to **bleep**. I try with "hidden" and "calculations" in the type column and also in the bind::esri:fieldType column I selected "esriFieldTypeInteger". But no luck, I don't why this is happening? Image 1: Image 2: when I use calculate in type column in row 8 Cheers, Federico

‎12-03-2020

Hi , I have created a new post with the XSLForm attached here is the link: https://community.esri.com/t5/arcgis-survey123-questions/sum-and-multiple-repeat-question-mean-estimate/td-p/1006620 Cheers, Federico

‎12-03-2020

Hi, Is have been able to sum repeated question. However, I have an unresolved issue, I have 7 repeated integer questions, that I need to sum in order to estimate the mean. I used the count function so I can then estimate the mean = total sum / total count answer question. The problem is that not always the 7 repeated questions will have a response, so that value will be NA or 0. I try to use coalesce to solve this issue, but is not working. I don't want the 0 value counted in the count function towards estimating the mean. I have try to get around this issue. Example: coalesce(sum(${producto_1.1.1})+sum(${producto_1.1.2})+sum(${producto_1.1.3}),0).... or sum(coalesce(${producto_1.1.1},0))+sum(coalesce(${producto_1.1.2},0))..... I'm attaching the XLSForm @DougBrowning @IsmaelChivite Cheers, Federico

‎12-02-2020

Hi @DougBrowning thanks for you response. I try this, but still have issues with the formatting and the sum of the repeats. When I choose "hidden" or "calculate" in the type column the calculation do not work. I can't upload my XLSForm here for some reason. Cheers, Federico

‎11-29-2020

Hi @erica_poisson , I have the same issue, not sure if this is working. Is working for me, to sum repeated question. However, I have an unresolved issue, I have 7 repeated integer questions, that I need to sum in order to estimate the mean. I used the count function so I can then estimate the mean = total sum / total count answer question. The problem is that not always the 7 repeated questions will have a response, so that value will be NA or 0. I try to use coalesce to solve this issue, but is not working. I don't want the 0 value counted in the count function towards estimating the mean. I have try to get around this issue. Example: coalesce(sum(${producto_1.1.1})+sum(${producto_1.1.2})+sum(${producto_1.1.3}),0).... or sum(coalesce(${producto_1.1.1},0))+sum(coalesce(${producto_1.1.2},0))..... Maybe @DougBrowning or @IsmaelChivite have an idea? Cheers, Federico

‎09-14-2020

Hi Carmel, thanks for your post, very helpful. How can I make this work with select_one_external? I have a very long list of name code for sampling site (I used select_one_external) but I want I have an option so the survey users can add a new name code for a new sampling site. Thanks for your help. Cheers, Federico

‎08-05-2020

Hi Zach, thanks so much for your help and input, this most needed by biologist and other researchers. The pulldata function option is probably the best, however, I wan't able to find an downloadable excel spreadsheet with this data on the web. I come across this calculation based on the date that I try to insert into XML Survey123 spreadsheet but without success: Phase = (((#DNOW#/2551442844-0.228535) +0.00591997sin(#DNOW#/5023359217+3.1705094) +0.017672776sin(#DNOW#/378923968-1.5388144) -0.0038844429sin(#DNOW#/437435791+2.0017235) -0.00041488sin(#DNOW#/138539900-1.236334))%1) link: Moon Phase formula - updated - Expression Help - FACER Community Thanks for the sample that hits a weather API based on a Geopoint location. Thanks again for you time and aid. Cheers, Federico

‎07-27-2020

Hi how can I include the lunar phase when I select the date in the Survey123 form? Any ideas Cheers F

‎07-14-2020

Hi Michael, I'm in the same path as you I'm trying to output Survey123 data to google sheets, I don't even manage to get any data into a google sheet. I there any info out there to be able to set this up correctly? Thanks in advance, Cheers, Federico integromat‌ Ismael Chivite‌ connect excel sheet‌ survey123

‎06-04-2020

It there a Local Government Solution for Residential Garbage Service & Recycle Pickup? There for water, gas and electricity, however, not for management of garbage, is there any that could be configure to do this job? Thanks

‎03-31-2020

Dear Geogeeks, I'm trying to estimate the growth rate (kg Dry matter/ha/day) for a series of sampling sites within pastures field for cows. However, this examples may apply to anyone estimating growth rate in any field of science or industry. The pasture fields (dry matter in kg) are sampled with Survey123 once (date, same day of the week) a week ( 7 days a part) and the growth rate is estimate taking account last week value and current value divide by 7 days, see image below. Each row represents a pastures field, same pasture field is samples the following week in order to estimate the growth rate of dry matter for each pasture field. How can I bring back the data from last week in order to make this estimate? One of the field that I calculate in Survey123 is Number of Week. I figure out that I could do this by configuring Pop-Ups with Arcade Expressions. How can I write this in Arcade Expressions? Any ideas are welcome. Many thanks Federico

‎03-31-2020

Hi Phil, thanks so much for your help. I'm was using a repeat to enter the set of values. In fact, area in ha for each sample is predefined and I have this data in a table in the media folder, and I used pulldata to bring the area data into the survey and it works wonderfully with your input. Indeed, as you said it was simple to create a xlsform expressions. Hope this help other colleagues in order to use sumproduct in Survey123. Cheers and take care Federico

Online Status	Offline
Date Last Visited	‎03-21-2025 12:46 AM

My Ideas

Latest Contributions by FedericoRiet_Sapriza

Calculate month between dates Survey123

Dashboard Serial Chart mean and standard deviation

Re: Sum and multiple repeat question, mean estimate

Re: Sum and multiple repeat question, mean estimate

Re: Sum values from multiple repeat fields

Sum and multiple repeat question, mean estimate

Re: Sum values from multiple repeat fields

Re: Sum values from multiple repeat fields

Re: Another Other in Survey123

Re: Lunar Moon phases dates in Survey123

Lunar Moon phases dates in Survey123

Re: Survey123 Tricks of the Trade: Integromat

Residential Garbage Service & Recycle Pickup Solutions

How to estimate growth rate between same sites sampled once a week, Arcade Expressions Pop-ups in Web Map

Re: Math trigonometry function (Sumproduct excel) in Survey123 XLSForm

Re: Sum and multiple repeat question, mean estimat...

Re: Survey123 Tricks of the Trade: Lines and Polyg...

Sum and multiple repeat question, mean estimate

Re: Math trigonometry function (Sumproduct excel) ...