Latest Contributions by Ryan_Gould

We are exploring options for processing events from a large number of GeoTab units. Our units have been collecting for the past 5 months. I would like to access this data. We can download directly from the GeoTab site, however the export options are Excel and PDF. Excel formats have a limit of 100,000 rows per file. Can the GeoEvent Server GeoTab Connector access historic (i.e. > 5 months ago) data? ... View more

I am trying to display the average event closures in a dashboard list using a GroupBy function. I would like to display the average closures per month and per week.  I'm trying to do this using a GroupBy expression that divides the total closed events by the program length. The test results either shows NaN (Not a Number), or no results.  I've tried using the Number function in the expression to convert the equation to a number, but this produces no results in the Test. Apparently can't use a variable in the expression because this again produces no results. I've tried adding fields for Total Weeks and Total Months. This doesn't work either.  I'm fairly new to Arcade . This seems like a simple task. Can some one show me where I'm going wrong?  Thank you   var fs = FeatureSetByPortalItem(Portal('xyz'), 'xyz', 0, ['*'], false); //Filter for closed events var fs_closed = Filter(fs, 'STATUS > 1'); //Count rourds after filtering var cnt = count(fs_closed); //return cnt var mths = 5 var wks = 22 // Return a featureset with single group by statistics. return GroupBy(fs_closed, ['TMM','FUNCTIONAL_ROAD_CLASS','CAMP'], [ {name: 'Average Reponse Time (hours)', expression: 'RESPONSE_TIME_H/1', statistic: 'AVG'}, {name: 'Average Reponse Time (days)', expression: 'RESPONSE_TIME_H/24', statistic: 'AVG'}, {name: 'Average Reponse Time (weeks)', expression: '(RESPONSE_TIME_H/24)/7', statistic: 'AVG'}, //Count the total records and divide by the program length. // {name: 'Average Closures Per Week', expression: 'cnt/prglnthwks', statistic: 'AVG'}, {name: 'Average Closures Per Week', expression: 'cnt/wks', statistic: 'MAX'}, //{name: 'Average Closures Per Week', expression: 'Count(OBJECTID)/prglnthwks', statistic: 'AVG'}, //{name: 'Average Closures Per Month', expression: 'cnt/prglnthmths', statistic: 'AVG'} {name: 'Average Closures Per Month', expression: 'cnt/mths', statistic: 'MAX'} //{name: 'Average Closures Per Month', expression: 'Count(OBJECTID)/prglnthmths', statistic: 'AVG'} ] );     ... View more

I have 7 elements stacked together in a dashboard. There are usually tabs displayed under the stack to move from element to element. In my dashboard, the tabs were replaced with right and left arrows. How can force tabs to appear? The arrows aren't as intuitive for users.  Here is what I would like to see:   This is what my stack looks like with the right and left arrows. Any help would be greatly appreciated! ... View more

This is probably a very simple question: I would like to run a standalone script that populates a field with a sequential ID sorted by a datetime field. I can run the code (below) successfully in the ArcGIS Pro python window, but when I try to run it in IDLE 3.7 the “rec” variable is not recognized. The error I receive is: “NameError: name 'rec' is not defined”. As I understand it, this means the code doesn’t know what “rec” is.  When I move rec under “Global rec” and the script runs in IDLE, but populates the entire column with 1.  Here is the python code I'm trying to use. Any help would be greatly appreciated! sortFeat = Road_Activity_Reports sortField = 'open_datetime' idField = 'open_rep_cnt' rec = 0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec rows = arcpy.UpdateCursor(sortFeat, "", "", "", sortField + " A") for row in rows: row.setValue(idField, autoIncrement()) rows.updateRow(row) del row, rows ... View more