Latest Contributions by KenBuja

You're using Push incorrectly in several places. I've restructured your code a little bit and it returns the Dict. // Define the feature set var Dates = FeatureSetByPortalItem( Portal('https://regionofpeel.maps.arcgis.com'), '5d0f25a7a3314686b526bab55653befb', 0 ); // Function to check if a string represents a valid date function IsDate(dateString) { // Check if the date string is not null, undefined, or an empty string if (dateString == null || dateString == "") { return false; } // Attempt to create a Date object from the string using DateTime function var dateObject = Date(dateString); // Check if the created Date object is a valid date return !IsEmpty(dateObject); } var i = 0; var totalWaitingTime = 0; var maxWaitingTime = -Infinity; var minWaitingTime = Infinity; var features = []; // Loop through records in the feature set for (var record in Dates) { var wellAbandonmentDate = record['Date_abandonment']; var dateReceived = record['date_recieved']; // Check if both dates are valid if (IsDate(wellAbandonmentDate) && IsDate(dateReceived)) { // Calculate waiting time in days using the DateDiff function var waitingTime = DateDiff(dateReceived, wellAbandonmentDate, 'days'); // Update total, max, and min waiting times totalWaitingTime += waitingTime; maxWaitingTime = Max(maxWaitingTime, waitingTime); minWaitingTime = Min(minWaitingTime, waitingTime); // Add feature to Dict var feat = { 'attributes': { 'WellAbandonmentDate': wellAbandonmentDate, 'DateReceived': dateReceived, 'WaitingTime': waitingTime } ); Push(features, feat) i++; } } // Calculate average waiting time var averageWaitingTime; if (i > 0) { averageWaitingTime = totalWaitingTime / i; } else { averageWaitingTime = null; } var Dict = { 'fields': [ {'name': 'WellAbandonmentDate', 'type': 'esriFieldTypeDate'}, {'name': 'DateReceived', 'type': 'esriFieldTypeDate'}, {'name': 'WaitingTime', 'type': 'esriFieldTypeDouble'}, // New field for waiting time {'name': 'AverageWaitingTime', 'type': 'esriFieldTypeDouble'}, {'name': 'MaxWaitingTime', 'type': 'esriFieldTypeDouble'}, {'name': 'MinWaitingTime', 'type': 'esriFieldTypeDouble'} ], 'geometryType': '', 'features': features }; // Loop through features for (var j in Dict.features) { var featureData = Dict.features[j]; // Add calculated values to the features featureData.attributes.AverageWaitingTime = averageWaitingTime; featureData.attributes.MaxWaitingTime = maxWaitingTime; featureData.attributes.MinWaitingTime = minWaitingTime; } return Dict; However, is your intent to just have one record for the maximum, minimum, and average waiting times for your indicator? All of the records in your dataset will have the same values for these three times.       ... View more

And you should click the Accept as Solution button in your response to help others if they have this problem. ... View more

Nice find! ... View more

It looks like "-8" is getting added to the beginning of the latitude of each point. When I examine one of the points in the response, its latitude attribute is "46.53949113" while the geometry latitude is "-846.5394911299999". I can't figure out where that is happening, since looking at the same point from the rest service shows the correct values. rest.png   response.png And you're getting lots of dojo errors when you used v4.28 since dojo has been been almost fully removed from the SKD ... View more

What does your domain look like? ... View more

var onlyRemoved = Filter(sortedTable,'Maintenance_Performed = 1'); //or whatever the domain code is for Removal You should use the numeric domain code, since the SQL function won't understand how to work with them. ... View more

It looks like you're having a spatial reference problem when making graphics from the query results. If you zoom out far enough, you'll see the records, but they're in a straight line. If you click the home button, the map shows up again. map.png Examining one of the points in the query results shows its latitude and longitude are kind of screwy. point.png ... View more

Is it possible that the Maintenance_Performed field uses a domain? ... View more

You need to put quotes around Removal in your filter var onlyRemoved = Filter(sortedTable,'Maintenance_Performed = "Removal"'); ... View more

Have you seen the new Time Only field now available? ... View more

Which web app are you using? Some of them are built with ArcGIS Maps SDK for JavaScript v3.x (like Web AppBuilder), which doesn't support group layers. Experience Builder uses v4.x, which does support group layers. ... View more