Latest Contributions by LindseyStone

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

I have an UN Electric Network set up with multiple Subnetworks and I'm running into an y issue where I have a a transformer and LV lines that it is connected to it not updating correctly after running the Update Subnetwork tool. What I did is I had a transformer connected to Subnetwork A and then I deleted the MV line making that connection and created a new MV line that connects it to Subnetwork B.  Than I ran the Update Subnetwork tool.  In the field "subnetwork name" instead of seeing the Subnetwork B name listed for both the transformer and all connecting LV lines I now see Subnetwork A:Subnetwork B. I have done this before and it usually just changes the subnetwork name to the new one and no longer lists the old name.  I have checked the Connected to, Contained within, and Connected to edge associations of the transformer and there is none.  The new MV Line only shows Subnetwork B.  If I move the old transformer where it is no longer connected to anything and create a new transformer and LV line at this location.  The OLD items retain Subnetwork A info instead of going Unknown and the New features only have Subnetwork B.  I really don't want to have to redraw the transformer and all LV Lines and Devices connected to the transformer if I don't have to. Has anyone else run into this issue and have a fix? ... View more