Latest Contributions by JayLarsen

Did you ever get an answer or figure this out? ... View more

Thanks for the reply! It's a shame that IT security ruins our fun like this. I played around with the Excel Office365 plugin at home on my Mac with my personal license ID and it was very cool--worked like magic. I couldn't believe it! ... View more

It's very common.  I work in healthcare, and MSFT store is locked out. It's really a problem because we relied on the old Excel plugin for several routine workflows that are no very difficult and time-consuming. My IT didn't even really seem to understand what and how the AppSource store worked...we are all Office365, so you'd think they would be hip to MSFT's concept by now. ... View more

Your best new friend is the SQL-style JOIN command.  It literally does everything you need. https://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm Good to have some of the table join lingo...right/left and inner/outer mid... https://en.wikipedia.org/wiki/Join_(SQL) Cheers! Now just imagine if those lazy slacks at MSFT would put a JOIN command in Excel at last.... ... View more

The easiest way to make a ZIP choropleth map (<--cool map nerd term) is to use the Excel plugin.   If you don't have that, it's going to be uploading the table and doing the table JOIN to the LivingAtlas ZIP layer. That's what the procedure in your link does.  It's worth knowing that technique, no matter what. Good luck, you're on the right track! ... View more

Yeah, it would be nice!  Especially since % is so common in mapping. My recollection is you have to format the number part and the label part both with 2 separate Arcade expressions to handle both labelling in the choropleth map and the legend.  Very annoying. Maybe somebody knows some magic to handle this? ... View more

A classic AGOL trick is to dupe the layer of interest and then set up multiple copies with all the different styles of interest. Just rename them something useful after duplication. The real trick you'll see is designing your data table that you upload to be able to show all you want. Fun times ahead! Enjoy! ... View more

Do you want to end up with a layer that shows the variable as a dot of various color and size in the center of the ZIP code?   Or do you want to make a choropleth, the typical ZIP shape colored in based on the variable?   Do you have access to the Office365 plugin for Excel or not?  If so, some shortcuts.   Otherwise, gotta do an upload as table, then do a JOIN with the actual ZIP code layer from Living Atlas.  That joins the variable from your table with the graphic so it can be styled. ... View more

Oh, one other thing in the folklore of this bug: try clearing cache in the browser.  Some have had luck with that. My office forced use of MSFT Edge a while back, and many report that more of this weird stuff happens due to that. It's always something. Cheers! Let me know if you hear any better solutions, you never know when this bug will strike. ... View more

This again! So annoying. Many have had this happen to us over the last month or so. It seems to be a glitch that happens when we create layers from Excel.  They are created properly, even used and edited. And if you go into a map with the layer, it works and you can even bring up the table.  But, you can't edit or see the other tabs by opening from content. There's one official fix: export it as a file geodatabase, and then re-import it. Also, what worked for me, was just not doing anything and it automatically fixed itself. So, depending on your timeline and what you have to do with it, pick your option. Some have also had luck with opening the layer on a different browser and platform. I opened it first with Firefox on a Mac, and after that everything was fine.  Don't know if it was coincidence. Maybe start a support call with ESRI and see if they have anything better to do now? I think they seem to know something is goofy on their server-side. Very frustrating. Good luck! ... View more

I tried the goofed up layers at work again, all are fine. 1. Opening up on Mac/different browser invoked a fix on the servers? 2. ESRI rolled out a magical fix that took care of things one night? 3. Cache in work browser expired or was refreshed? Another very weird and disturbing incident. Whenever I really really need AGOL to work, I seem to run into these problems. But, more often than not, they magically fix themselves. Cheers everybody! There were multiple threads like this, and it was great to see there was really something going on. ... View more

I tried from home on a Mac running Firefox. They goofed up layers all worked. So maybe it was a cache or windows/edge thing? Thanks for the info, everybody. ... View more

Today I tried from a different computer, a Mac at home, and the "busted" layers all worked. So maybe it is a windows/edge thing?  I was using Firefox on a Mac. Or, it could be that it was a cache problem on just he 2 windows/edge machines at work. Or it could be that ESRI did a magical fix or some other routine "healed" the layers. The real test will be going on site tomorrow and seeing if they work from my office windows/edge setup.   ... View more