Latest Contributions by Miguel-Fernandez

Good morning all,   I am looking for some clarification on an issue I'm having with Survey123 and Operations Dashboard. I have built a survey using Survey123 Connect version 3.5.166 and a dashboard that visualizes the results from the survey. I am using the List widget in the dashboard to display details from the survey. When the survey first went live, everything was configured nicely in the dashboard. Now that I have made a few updates and changed a few attributes, the dashboard displays the value from the name column and not from the label column as it did when it was first implemented. I have attached two images to highlight my issue. In the image, list_transit_alert.PNG, you can see that the bottom most survey from 10/14/2019 at 11:30 AM has a Status of 'Suspended Service' and Length of Delay 'More than 30 Minutes'. Those were configured in the first version. If you look at the top two details, you can see Length of Delay for the first survey as '11_15_minutes' and Status from the second report as 'on_time_shuttle_hold'. Both of these values as well as others have been added in subsequent versions. In the second image, Survey123_connect_transit_alert.PNG, you can see how I have configured the choices in Survey123 Connect. The first version displayed values from the Labels column on the right, but now that I have added choices, the values from the name column in the middle are the ones being displayed. Does anyone know how I can get the values from the Label column to display in the dashboard as they did in the first version? Any guidance would be appreciated.   Thanks, Miguel Fernandez ... View more

Good morning all, I am looking for some clarification on an issue I'm having with Survey123 and Operations Dashboard. I have built a survey using Survey123 Connect version 3.5.166 and a dashboard that visualizes the results from the survey. I am using the List widget in the dashboard to display details from the survey. When the survey first went live, everything was configured nicely in the dashboard. Now that I have made a few updates and changed a few attributes, the dashboard displays the value from the name column and not from the label column as it did when it was first implemented. I have attached two images to highlight my issue. In the image, list_transit_alert.PNG, you can see that the bottom most survey from 10/14/2019 at 11:30 AM has a Status of 'Suspended Service' and Length of Delay 'More than 30 Minutes'. Those were configured in the first version. If you look at the top two details, you can see Length of Delay for the first survey as '11_15_minutes' and Status from the second report as 'on_time_shuttle_hold'. Both of these values as well as others have been added in subsequent versions. In the second image, Survey123_connect_transit_alert.PNG, you can see how I have configured the choices in Survey123 Connect. The first version displayed values from the Labels column on the right, but now that I have added choices, the values from the name column in the middle are the ones being displayed. Does anyone know how I can get the values from the Label column to display in the dashboard as they did in the first version? Any guidance would be appreciated. Thanks, Miguel Fernandez ... View more

I am trying to analyze commute patterns using LODES data from the US Census. I downloaded a table that contained fields for home_census_block, work_census_block, and num_of_jobs. I joined that table to the census block geography using home_census_block as my join field. I then made a selection of census blocks that I wanted to analyze as the starting location for the commutes and made a new layer from that selection. I then created a relationship between the census block geography layer and the census block selection. The parameters for the Add Relate tool are: Layer Name: census_block_geography Input Relate Field: census_block_geography.GEOID10 Relate Table: census_block_selection Output Relate Field: work_censusblockID Cardinality: One to many  The Add Relate tool runs fine with no errors but I can't seem to get what I want. What I'm trying to see is what census blocks people are working in that live in the selected area. I have tried using the 'select related records' from the attribute table menu but nothing happens. I'm wondering if this is the right approach or is there something different I should be doing to get the desired results. Any guidance would be much appreciated. Thanks, Miguel ... View more

Good afternoon, I am struggling with creating a nested if statement in the XLSForm for Survey123 Connect. I have a select multiple question that I am trying to count the number of times a selection is made. This is done through a hidden question type with a formula. For example, I have options in the select multiple list for Route 1 EB, Route 1 WB, Route 2 EB, Route 2 WB. Then in a dashboard I have a serial chart with counts for Route 1 and Route 2, etc.  I am wanting the counts for Route 1 EB, WB, etc to be added in the hidden question total_route_1. In the survey, Route 1 EB could be selected, Route 1 WB could be selected, or both could be selected. This is the formula I have written and I can't seem to get it to work. if(selected(${routes},'route_1_EAST') and not(selected(${routes},'route_1_WEST'),1, or (selected(${routes},'route_1_WEST') and not(selected(${routes},'route_1_EAST'),1, or (selected(${routes},'route_1_EAST') and selected(${routes},'route_1_WEST'),2,0)))) ‍ Any help would be appreciated. Thanks, Miguel Fernandez ... View more

Using Survey123 Connect 3.5.166 I have created a survey. The first question is a Date/Time field that is auto-populated when the form is opened using the now() function. There seems to be an issue during the 12 noon hour where the survey is populated with 12:xx AM instead of 12 PM. When 1 PM comes around, the form is populated with the correct time. I am using the latest version of Google Chrome to view the survey and the form is stored in my organization's ArcGIS Online account. Has anyone else experienced this or is this a bug? Thanks, Miguel ... View more