Latest Contributions by SaraJK

I would like to recommend that the chart viewer instant app have a more obvious way to switch between multiple charts. Right now, there is a 3 button icon that I am not confident the general public is going to notice so I will need to write instructions in the intro panel. Maybe a drop down list or better, some tabs with the name of the chart already listed. ... View more

I have a file geodatabase that is being hosted as feature layer on AGOL. It has both layers and tables. I have several web maps set up with both layers and tables in them which are being used for several dashboards. I need to update the schema of my database (so uploaded a new one) and assumed I could use AGOL assistant to update the URLs in the web map. The update to the layer URL seems to be working, however the tables still point to the old layer. I tried to find/replace the path and also tried to update the JSON directly. Is this a limitation with the Assistant? Do I have to recreate all the web maps?  ... View more

I have a time series table with a value field for each day. I need to create a expression to add a field showing the date from 4 days previous to the current date and the value from that earlier date. I see there is a DateAdd function but I kind of need the opposite of that. Not sure DateDiff will work because it's calculating the difference between two known dates. I know the current date and the difference, but the second date is unknown (and will change every day when the data updates). For example, 1) subtract 1/1/2020 - minus 4 days = 12/28/2019, 2) Find the value from 12/28/2019 and assign it to the expression to display in the pop up. Thanks for any ideas. ... View more

I went to create a page on my basic Hub site today. I clicked on new page, added the title and clicked Next. It appears the page is created as the template for a new page appears. I made a couple small edits, then clicked on Save, then View. The View links to "null" - there is no address (just "null" in the address) so a blank page opens in the tab with an error. Then when I go back to the list of pages in the Hub, the new page is not there, only the two existing ones. I have only had it open in one tab and I haven't been working on this site in a couple weeks at least. Seems like something on the back end perhaps? Edit: It seems to be specific to this Hub as I just tried to add a page on a different Hub and it worked as expected. ... View more

I am working with COVID19 case data and created a dashboard. I have a Jupyter Notebook inside ArcGIS Pro to process the heath dept.'s CSV file everyday. That said, I am a complete novice with Python and fumbled my way though but got something working. I now have a request to show the daily change in cases from the previous day. The source data table just lists the cumulative cases each day over time and lumps the dates together: ID   Date   FIPS   Cases 1   5/7/20   001   25 2   5/7/20   002   13 3   5/6/20   001   23 4   5/6/20   002   9 5   5/5/20   001   21 6   5/5/20   002   8 7   5/4/20   001   21 8   5/4/20   002   6 I would like to add a field where it contains the change in value from the previous day: ID   Date   FIPS   Cases   Difference 1   5/7/20   001   25            2 2   5/6/20   001   23            2 3   5/5/20   001   21            0 4   5/4/20   001   21            0 (because this is the starting value) 5   5/7/20   002   13            4 6   5/6/20   002   9              1 7   5/5/20   002   8              2 8   5/4/20   002   6              0 (start) The goal is a time series chart showing the sum of the daily changes for all FIPS by date (but might need to show them by FIPS as well). I know others are doing it but maybe their source data is supplied that way.  This seems like it should be fairly simple but I don't know where to start. Right now I am downloading the csv, truncating the table in my GDB, then appending the csv data to the table to refresh it every day. I think I need a bit of code to run daily to recalculate the difference after I grab the new day's values.  Appreciate any direction. Thanks! ... View more