Latest Contributions by JayJohnsonWashoeCounty

I have an AGOL hosted view of Covid-19 case data that includes a zipcode polygon layer with a one to many join to a patient data table.  This hosted view was created using the AGOL Analysis, Summarize Data, Join Features tool.  The patient data table has one row for each patient and a field for their ZIPCode.   https://services.arcgis.com/iCGWaR7ZHc5saRIl/arcgis/rest/services/Join_PatientZip_to_ZipCodes_Centroid/FeatureServer  I'd like to tally how many cases are in each ZIPCode polygon and add this to a webmap.  The data changes daily, so I'd like to do this as a view, not as a static layer. I can successfully return summary numbers in the REST API Query as shown below.  The question is, how do I translate this into a URL string I can add as a data source to a webmap, where each zip code polygon has a count of total cases? It seems like I should be able to append a URL string to the REST endpoint given above (yes?).  Something along the lines of: &groupByFieldsForStatistics="zipcode_text"&outStatistics="somethingelse"   Apparently I don't know how to construct the "somethingelse" portion of the string properly. Is this the right approach?   Thanks, Jay ... View more

I have a point layer of zipcode centroids with an attribute value of COVID-19 cases for each zipcode.  I am currently displaying counts per zipcode as "Counts and Amounts(size)" based on the value that attribute for each record.  What I would like to do instead is symbolize by "% of total cases".  Is there a way to do this without adding a field to the zipcode centroids that contains the # total cases (sum of all records)?  In other words, is there a way (Arcade or otherwise) to utilize the total summed value of an attribute field in a table without using a second field that explicitly contains that total value? ... View more

I've created a stand-alone hosted Table in AGOL (i.e. just tabular data, no spatial components) and would like to allow users to add records to this table.  Do any of the ESRI web apps (Geoforms, etc.) have this functionality for hosted Tables?  I belatedly remembered that Survey123 requires a Feature Service and so far as I can see won't work with just a Table.   ... View more

I have a hosted table with many records and would like to create a view layer from this that only shows the most RECENT record.  I've created a view layer and attempted to update the view definition using the TOPFILTER via the admin API. Original Layer Definition: { "adminLayerInfo" : { "tableName" : "db_4176.user_4176.CASES_TABLE_CASES_TABLE", "geometryField" : null, "xssTrustedFields" : "", "viewLayerDefinition" : { "sourceServiceName" : "Cases_Table", "sourceLayerId" : 0, "sourceId" : 984, "sourceLayerFields" : "*" } }, "id" : 0, "name" : "Cases_Table", "type" : "Table", "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, ETC... I think I need to insert something like the following, but can't get it to work successfully: "viewLayerDefinition" : { "topFilter" : { "orderByFields" : "reportdt ASC", "topCount" : 1 } } Does anyone have an example of successfully using topFilter (or some other method) to filter a layer view down to just the most recent record?  This is in support of a COVID-19 project. Thanks Jay ... View more

I'd like to create a serial chart in Dashboard that shows a rolling average - showing the average change in the total COVID-19 cases over the past 7 days.  Is there any way to do this from a simple table of cases, where each row in the table contains the date and a case count? Here is an example of the result I'd like to end up with (this is from NY Times): ... View more