Latest Contributions by DougBrowning

Looks like topnumber you are not sorting in descending order with OrderBy See here  https://developers.arcgis.com/arcade/function-reference/featureset_functions/#orderby  in counter you are taking the max so I do not think you even need orderby really.  But then you are adding onto objectid and not the actual count of records.  This may be ok though since it would cover you on deletes. this may work var counter = Number(Max(numberlist,'OBJECTID')) Also if the user does not take all the records offline this could fail on you.  Overall we just gave up on numbering as we do not really need it anymore. ... View more

@JeffBarrette   Could this explain my issue here? https://community.esri.com/t5/arcgis-pro-ideas/set-symbology-s-lower-value-manually-in-arcgis-pro/idc-p/1584218#M33756   ... View more

I am stuck trying to do this script.  If the range is really small like =.0003 to .00003 it will completely ignore my custom breaks and use a totally made up scale.  If the range is medium the breaks take but then the map gets all one color - the min value color.  This is totally wrong and users get the wrong idea.  In my case I have -100 to 100 for percent's.  If the range is -7 to 8 then I get ALL of the map getting the color of -40.  These maps are generated in a GP tool on the fly and need them all to have the same symbology. Totally stuck.  Any ideas.     sym = rasterLayer.symbology sym.updateColorizer('RasterClassifyColorizer') # was Condition Number sym.colorizer.colorRamp = project.listColorRamps('Prediction')[0] sym.colorizer.classificationField = "Value" sym.colorizer.breakCount = 10 #sym.colorizer.noDataColor = {'RGB': [255, 255, 255, 100]} # manual breaks # this will fail on small time periods if len(sym.colorizer.classBreaks) == 10: sym.colorizer.classBreaks[0].upperBound = -100 sym.colorizer.classBreaks[0].label = "Over -40%" sym.colorizer.classBreaks[1].upperBound = -40 sym.colorizer.classBreaks[1].label = "-30% to -40%" sym.colorizer.classBreaks[2].upperBound = -30 sym.colorizer.classBreaks[2].label = "-20% to -30%" sym.colorizer.classBreaks[3].upperBound = -20 sym.colorizer.classBreaks[3].label = "-10% to -20%" sym.colorizer.classBreaks[4].upperBound = -10 sym.colorizer.classBreaks[4].label = "0% to -10%" sym.colorizer.classBreaks[5].upperBound = 10 sym.colorizer.classBreaks[5].label = "0% to 10%" sym.colorizer.classBreaks[6].upperBound = 20 sym.colorizer.classBreaks[6].label = "10% to 20%" sym.colorizer.classBreaks[7].upperBound = 30 sym.colorizer.classBreaks[7].label = "20% to 30%" sym.colorizer.classBreaks[8].upperBound = 40 sym.colorizer.classBreaks[8].label = "30% to 40%" sym.colorizer.classBreaks[9].upperBound = 100 sym.colorizer.classBreaks[9].label = "Over 40%" else: arcpy.AddMessage("Warning Trend Rasters may not work with short time frames. Trying reduced symbols.") sym.updateColorizer('RasterStretchColorizer') sym.colorizer.colorRamp = project.listColorRamps('Condition Number')[0] sym.colorizer.stretchType = "StandardDeviation" rasterLayer.name = "Total Change" rasterLayer.symbology = sym      If I save out the map I got the correct range but colors are wrong. Why is it getting blue? Also really wish we could set an exact range.  This upper bound thing is so confusing esp with negative numbers.  Plus what I want to leave certain values out?  Let me set a upper and lower and call it a day please. Then if I add a interval in Pro it still lumps -7 to -100 at the top.  This seems way wrong right?   thanks   ... View more

I do this in several forms. You need to sum at each level of the repeats.   You have a parent, child, grandchild if triple nested.  Add a sum() at the child level that sums up the grandchildren then add a sum at the parent level that sums up the child sum field.  This will get them all. Hope that helps ... View more

@jeffhyderBRVA  For Excel take a look at ArcGIS for Excel.  You can connect to the service directly live time.  No need to download anymore.  My guess is no special license needed either.  Can add maps and even edit with domains in Excel. ... View more

Grids are about as close as you can get.  https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-groups-grids-and/ba-p/895267 Yours may be a bit too many fields to fit but you could try some variations. ... View more

Running into this today.  Waited over an hour to just delete 86,000 records.  Brand new map twice.  I was able to calc a field in a few minutes. Usually some of this caused by relates where a parent delete will go Null all the child keys on you - which it really should NOT do since it is a "unmanaged" relationship class. ... View more

You have several dup field names like generated_note_field_70.  You also have several using reserved words like label and final.  You also end some in _ which is not a good practice. Looks like you are not using the template is your biggest issue.  It will check for all of this for you and mark then in green for reserved. And in Red for dups.   I suggest you start with a brand new blank template and bring over each column - MAKING SURE to use Right click Paste Values.  This way the formulas in excel to check all this is not overwritten. Then all of this is easy to see.  You never want to mess up the template.  Not even sure how\why you did this. Hope that helps     ... View more

Please wrap text everywhere always!  Attribute table I'm looking at you.  But seriously just make it a standard habit. ... View more

You need to go into the AGOL item page for the feature service and delete it there. As far as order that is always a pain that Esri really needs to fix already.  If its a AGOL webmap then you can change it in the popup and it respects that - well sometimes. ... View more

Over 5 years later and I also need this.   ... View more

May consider the Esri certifications also. ... View more

We are mostly still in WAB as ExB is still missing so many things.  We are building and testing now though. But using the latest on AGOL the widget does not respect selections from the selection widget.  This was listed as a known issue fixed in 11.4 posted here  https://community.esri.com/t5/arcgis-experience-builder-questions/use-selected-features-as-input-to-analysis-tool/m-p/1396535 But we are using AGOL so not sure what that has to do with server? The one spot said to use Set as Analysis input.  I do that and again it still has all the features and not what is selected.  Well wait it works from some places and not others.  It seems similar to WAB in a way.  If I select using the select widget it gets ignored.  If I select in the widget then use set as input it works.  If I select then Set as from the layers list also ignored.  Been confusing to users. thanks a lot ... View more

@Robert_LeClair  Not sure why I just saw this but I do have it set to User defined and it still does not work.  Note bug in Pro that you have to set this manually AND you have to reset it on every single Overwrite publish.  So I know I do it. ExB same deal. This is driving users nuts.  Any other things to try? Update testing again and a selection in the attribute table does work but when using the Select tool it does not work.  Even though the same button. ... View more