Latest Contributions by LindseyStone

I'm trying to create a special arcade function in a Dashboard List (Enterprise 10.9.1) that finds the unique between two fields and then counts the number of one field.  The below screenshot is a example of data.  I have entries with multiple subnetworks.  Within the subnetworks there is accounts, the accounts can be duplicated across the same subnetwork and across other subnetworks.  I want to find only where the subnetwork + account are unique (this way the accounts that run across multiple subnetworks can be counted in each).  Then once I find the unique I want a count of each account  within each Subnetwork.  Below is utilizing the GroupBy function that I get the first GroupBy to work, but the second GroupBy returns a blank table.  I also tried the Distinct function and I get similar results and the Distinct tends to crash the entire Dashboard.     var portal = Portal(portal url); var secondary = FeatureSetByPortalItem(portal,'1bb7df369ca44c8880d65011fa3d69e6',40,['*'],false) var service = Filter(secondary, 'lifecyclestatus = 8'); var sub = GroupBy(service, [ {name: 'Subnet', expression: 'SUBNETWORKNAME'}, {name: 'acct', expression: 'account'} ], [ { name: 'SubAccountCount', expression: '1', statistic: 'COUNT' }, ] ); var gsub = GroupBy(sub, ['Subnet'], [ { name: 'Subnetwork Count', expression: '1', statistic: 'COUNT' }, ] ); return gsub         ... View more

Let me start with I'm very new to Python so please bare with me.  I have created a python script that deletes a feature layer "ElectricMeterDuplicates" out of a GDB, runs some other calculations commands and then exports the results back into the original GDB as a feature layer with the same name.  That part is all working correctly until I get to my text file I want to write results to.  I could have one of two situations. 1. the new feature layer contains 2 or more rows of data, here I want it to write to the text file the information form 2 fields for each row of data. OR the feature layer is empty and here I want it to write to the file I simple message of no data .  I have written the below script.  When I run it in Notebook within Pro it correctly writes to the text file if there is data, however, if there is no data it doesn't write anything.  When I run this as a standalone script through a bat file (which is my end goal, the entire thing errors out with ERROR 000732: Input Rows: Dataset ElectricMeterDuplicates does not exist or is not supported and doesn't write anything to the text file no matter the situation. epath = r"Z:\General\Projects\Utility\Scripts\DuplicateMeters\Logs\ElectricDupMeters.txt" efile = open(epath, 'a') etable = r"Z:\General\Projects\Utility\Scripts\DuplicateMeters\DuplicateMeters.gdb\ElectricMeterDuplicates" fields = ['meternum','assetid'] today = str(date.today()) total = 0 row = arcpy.management.GetCount( in_rows="ElectricMeterDuplicates" ) print (row) if row == 0: print ("Empty List") efile.write("No Duplicate Meters on " + today + "\n") else: with arcpy.da.SearchCursor(etable,fields) as cursor: for row in cursor: print ("Meter {} is duplicated on Asset ID {}".format(row[0],row[1])) efile.write("Recorded On " + today + " Meter {} is duplicated on Asset ID {}".format(row[0],row[1]) + "\n") efile.close()   ... View more

I have an Experience Builder App set up with 2 pages, both with their own maps.  When navigating between the pages I have ran into an issue with the map tools where they do not close out when you switch pages and stays hovering on the next page until I click the X to close out.  For example on Page 1 I open the layer list via page 1 map, then I switch to page 2,  the layer list from page 1 map is still being shown on the screen, until I close it.  Same thing happens if I open the layer list on page 2 map and go to page 1, I will continue to see the layer list on page 1 until I close out of it. I have tested multiple map tools and all of them I tested did this.  The only time it doesn't happen is when it is sized down for mobile devices. This Experience Builder app is in my 10.9.1 Enterprise Portal. ... View more

I'm trying to create a data expression in the List of a Dashboard to pull statistics from the different status of several features.  I have set the Group By expression on my status field and calculated the SUM on many of the fields and have that working.  The part I can't figure out is I want to determine the duration taken to complete the entire project for each category.  So I need to take the lowest start date from all the features in said category and the highest end date from the same category and Difference them.  So in each category I know how many days it took overall.  Note, some features start date or end date may overlap as we would have one person starting and ending in one area, and another person starting and ending in a different area at different times. This is what I have so far, I just don't how to fit the variable durationcalc into the group by so it returns it as part of the table for each category. //Define Portal Item and Fields var fs = FeatureSetByPortalItem(Portal('portal'), 'item', feature, ['surveystatus','belowleaks1','belowleaks2','belowleaks3','aboveleaks1','aboveleaks2','aboveleaks3','footagemains','numberservices','startdate','enddate'],false); //define duration var sdate = Min(fs, 'startdate'); var edate = Max(fs, 'enddate'); var durationcalc = DateDiff(edate, sdate, 'days'); //Group By Survey Status and calc Sums on leaks return GroupBy(fs, ['surveystatus'], [ { name: 'Underground Leaks Class 1', expression: 'belowleaks1', statistic: 'SUM' }, { name: 'Underground Leaks Class 2', expression: 'belowleaks2', statistic: 'SUM' }, { name: 'Underground Leaks Class 3', expression: 'belowleaks3', statistic: 'SUM' }, { name: 'Aboveground Leaks Class 1', expression: 'aboveleaks1', statistic: 'SUM' }, { name: 'Aboveground Leaks Class 2', expression: 'aboveleaks2', statistic: 'SUM' }, { name: 'Aboveground Leaks Class 3', expression: 'aboveleaks3', statistic: 'SUM' }, { name: 'Miles of Main', expression: 'footagemains', statistic: 'SUM' }, { name: 'Num of Services', expression: 'numberservices', statistic: 'SUM' }, //Determine the earliest start date of all features and the latest end date of all features { name: 'Start Date', expression: 'startdate', statistic: 'MIN' }, { name: 'End Date', expression: 'enddate', statistic: 'MAX' },])   ... View more

I have a layer hydrant and a related table hydrant inspection that live in an Enterprise SDE.  I want to visualize the hydrants based on if certain fields have been marked Yes or No in the hydrant Inspection table.  On the hydrant Inspection table I did a definition query of "maintcomplete IS NULL And followup = 1" so it only give me records saying that it needs follow up and that follow up hasn't been completed.  I then joined by hydrant layer to the the hydrant Inspection record with the definition query.  I then Shared this as a Map Image Services to my portal. I'm now able to visualize the hydrant that have the follow up marked as 1 (Yes) and the layer updates as new inspections are added via Field Maps or as the Maintenance Completed field is filled out. I then go to put this functioning Web Map into a Dashboard and the indicator widget or other items to be able to see data on this layer and when I select this joined feature service within Dashboard I get "Cannot Access Data".  I go to the Server Manager logs and I'm getting "Geodatabase error: The SQL statement was not a select statement." Does Dashboards have the ability to pull data from the Joined feature services?  I'm able to view the table of attributes of this Joined feature service in the web map without issue.  Or do I need to modify my definition query?   ... View more