Latest Contributions by EvanTimms

I have a survey123 form that is populating a dashboard used for structure protection. The form has a repeat in it where the user can go in, enter information about the property/structure, and then add a repeat in if the water source is coming from a pump. If the pump is deployed, the user will set pump_status to Current, and then if it is retired, they will add a repeat and set the pump_status to Retired. In the data table for the pumps, I have included the following fields: track_pump - unique ID so that I can relate the property information from the main table to the pump (client required). Includes a concatenation of fields, including an address. CreationDate - autogenerated pump_status - user fills out whether the pump is Current or Retired using a repeat. property_status_current_pump - calculated in the survey, based on what the user had entered as the property status. Property status is it's own repeat and moves from Triaged to Protected to Demobilized, based on the level of protection required.   In short , what I would like to do is take the list of pump features, and sort them by the address that is in the track_pump. Each address will eventually have two entries - one for Current, when the structure is Protected, and one for Retired, when the structure is Demobilized. I would like to take this list of pump features sorted by address, and then if the address has a pump that is Current and does not have an address that is Retired, then add it to the list. If the address has a pump that is Current and the pump at the same address has been Retired, I don't want to include it in the list. I am looking for a count of how many pumps are only Current, and none of those which have both Current and Demobilized. Thank you!   ... View more

I am currently working with a serial chart in Operations Dashboard, viewing USGS Earthquake data by Magnitude for All Events - it is a map service. I have the data on Categories From: Features, based on Event Time (which in the data table looks to be formatted: MM/DD/YYYY, HR:MM:SS ex. 2/19/2020, 11:01:01 AM). This is how I want the data to appear in my chart category labels, but it brings up GMT-0800 (Pacific Standard Time) at the end of the label.  I want to format the labels so that it displays everything up to but not including GMT. Thanks! usgs‌operationsdashboarddateformat#serial charts ... View more

I am currently working with a serial chart in Operations Dashboard, viewing USGS Earthquake data by Magnitude for All Events - it is a map service. I have the data on Categories From: Features, based on Event Time (which in the data table looks to be formatted: MM/DD/YYYY, HR:MM:SS ex. 2/19/2020, 11:01:01 AM). This is how I want the data to appear in my chart category labels, but it brings up GMT-0800 (Pacific Standard Time) at the end of the label.  I want to format the labels so that it displays everything up to but not including GMT. Thanks! usgs‌operationsdashboarddateformat#serial charts ... View more