Latest Contributions by KellyDoss1

The blog was very helpful, thank you! This is what worked: .> date(decimal-date-time(now()) + 15) ... View more

Thanks, but unfortunately that did not work and I got the same error message again using any date. Is your field dateTime or just date? ... View more

Hello, I have shared an AGO group with you that has my feature layer in it. As I’ve been researching through Esri documentation and blog posts on how to create the desired dashboard, I’m wondering now if I’ll be able to even get there using the current data schema. So before continuing with doing research, working out attribute expressions, and testing for my popups, I’d like to give you some history and what I’d like to accomplish. I’d appreciate if you can let me know if it’s feasible and what would be needed to make it happen. Our current Capital Projects viewer that was created many years ago in SQL is here: http://cip.durhamnc.gov/ In its current state, it hasn’t been possible to have a mapping component because the only geographic information included is a parcel PIN, and that won’t work and is blank for many projects. City management has requested that we create a more updated viewer that includes a map, and would like a dashboard that has charts and graphs as well. Phase 1 of the overall project is creating the viewer using existing data. For the mapping component, I created polygon and point (with many points for multipart polygons) feature classes with the Account Number, then joined and related tables that were exported from the existing SQL database; I tried adding a Query Layer, but it wouldn’t publish. The feature layer in the group that I shared with you is these polygon and point layers and the related tables. Ideally, I was hoping to make a Capital Projects Operations Dashboard<https://solutions.arcgis.com/local-government/help/capital-project-dashboard/> or use Web AppBuilder with the Dashboard theme. It would include filters for Service Area, Fiscal Year, Completed Projects, etc., the popup panel would include Phase data, and there would be charts for the Expenditure and Financials tables. Is this even possible with how the data is currently setup? If not, do you have any suggestions on how to properly setup my data schema so that all needed data is in one table? I’ve viewed the feature layer, map, and dashboard included with the Capital Projects Dashboard Solution to see its schema and settings, and, along with your popup arcade expression help, it is greatly helpful for the popups, but not for the expenditure and financial data. Phase 2 of the overall project is converting to a new system that can be used for all city projects, not just capital projects. My department was going to test drive Aurigo, PPM software and an Esri partner, but that has hit a snag. Thank you so much for your time. From reading through the blog posts and help requests, you are an incredible asset to the community! I’ve been at my job for a little over a year now, and my whole team is learning all of the new AGO and Portal capabilities on the fly as needed. Kelly Doss, GISP GIS Analyst Technology Solutions Dept. City of Durham 101 City Hall Plaza Durham, NC 27701 P 919-560-4122 x33218 F 919-560-4808 Kelly.Doss@durhamnc.gov ... View more

Thank you so much for taking the time to help me! I’ll let you know if I have success. Kelly ... View more

Xander Bakker‌ I had posted this same question at the bottom of the "Overlapping Features in Pop-Ups.....FeatureSets with Arcade" blog post and you responded with: " Hi   You could probably try something like shown below. Keep in mind that you need to change some field names to match your data. The idea is to get the ID from the current feature and create a filter to get the related project phases. This is sorted descending on the date and you get the first element from the result, which should be the most recent change in project phase. var yourid = $feature . YourIdField ; // change the name of the field var tblphases = FeatureSetByName( $map , "CIP Test - Project Phase"); var sql = "YourIdField = '" + yourid + "'"; // if field is text var relphases = Filter( tblphases , sql ); var cnt = Count( relphases ); Console( cnt ); var result = ""; if ( cnt > 0) {     result = "Project phase:" + TextFormatting . NewLine ;     var currentphase = First(OrderBy( relphases , 'DateModified DESC'));     result += "Date : " + currentphase . DateModified + TextFormatting . NewLine ;     result += "Phase: " + currentphase . ProjectPhase ;     return result ; } else {     result = "There are no project phases defined"; } return result ;   If the data is related using a relationshipclass, it can be done in a more easy way." My question is for this last sentence.  I've setup my data now in ArcMap with relationship classes and published it as a feature layer.  Can you explain the easy way, please? Thanks, Kelly ... View more

Hello all, I'm pretty new to Arcade and I think this is the right blog for what I want to do, but I'm having problems. I have a hosted feature layer with several related tables, some of which are 1:M.  In the CIP_Test pop-up, for the 1:M related tables, I only need to show the data from the rows with the latest "Date Modified". I've attached a screenshot of the related table.  Where there are duplicate AcctNo, I only want to show the ProjectPhase (and maybe other fields) for the record that was last modified. Any suggestions on how to do this are much appreciated!  I have gotten nothing but errors in everything I've tried from any forum posts I've found.... ... View more