Latest Contributions by KenBuja

You could create an array of DateOnly holidays and test whether today as a DateOnly is in that array var holidays = [ DateOnly(2025, 0, 1), //Months are 0-based DateOnly(2025, 0, 20), DateOnly(2025, 1, 17), etc... ]; if (Includes(holidays, DateOnly())) { return "Closed (Federal holiday)"; } else { iif(current >= start && current <= end, "Open now", "Closed"); }   ... View more

If you had one entry per year in your data, you could have used the same GroupBy to create the two new columns dividing the sum of the federal (or local) investments by the sum of all investments. However, that won't work with multiple rows per year. Instead you take the grouped FeatureSet and run another GroupBy to calculate those numbers. var grouped = GroupBy(fs,"Year", [ { name: "Fed_Funding", expression: "Fed_Fund_1 + Fed_Fund_2 + Fed_Fund_3", statistic: "SUM" }, { name: "Local_Funding", expression: "Local_Fund_1 + Local_Fund_2 + Local_Fund_3 + Local_Fund_4", statistic: "SUM" } ] ); GroupBy(grouped, "Year", [ { name: "Federal Funding", expression: "Fed_Funding", statistic: "Max" }, { name: "Local Funding", expression: "Local_Funding", statistic: "Max" }, { name: "Total Investment", expression: "Fed_Funding + Local_Funding", statistic: "Max" }, { name: "Federal Percentage", expression: "Fed_Funding/(Fed_Funding + Local_Funding)", statistic: "Max" }, { name: "Local Percentage", expression: "Local_Funding/(Fed_Funding + Local_Funding)", statistic: "Max" } ] ); ... View more

When you add an element to the dashboard, you have the choice of selecting a layer or a data expression. If it's an empty dashboard, you'll be present with this dialog If you're using an existing dashboard, you'll see something like this dialog  In either case, click "New data expression" to add your Arcade code. ... View more

This solution uses template literals and an implicit return IIf( $feature.province_code > 59, `${$feature.both_rate_12}, ${$feature.both_rate_10}`, `${$feature.both_rate_6}, ${$feature.both_rate_4}` );   ... View more

Use the Pow function to raise x to the power of y var D = 0.7; if (IsEmpty(D)) return null; return Pow(D - .62, 2.48) * 2.49 * 448.8;   ... View more

You are returning a Dictionary, not a FeatureSet. You just need to wrap that Dictionary in the FeatureSet function var capa = FeatureSetByPortalItem( Portal(""), "597723f82afb4031a8211a2a993c7688", 0, ["estado"] ); var total = Count(capa); var rechazadas = Count(Filter(capa, "estado = 'Rechazada IPEEM/Archivo'")); var porcentaje = IIf(total == 0, 0, Round(rechazadas / total * 100, 1)); return FeatureSet( { fields: [{ name: "porcentaje", type: "esriFieldTypeDouble" }], geometryType: "", features: [{ attributes: { porcentaje: porcentaje } }] } ); ... View more

It would help if you provide the code. Are you trying to access fields that don't exist in that particular layer? ... View more

There are a few things that need to be fixed in your code. The TypeOf documentation seems to be incorrect. It returns "String" instead of "Text" for text. (line 15) Use "Count" instead of "Length" to return the length of a string (lines 20, 21, and 28) // barcode variable from feature attribute var barcodeValue = 'BTR7981006'; Console('Barcode Value: ' + barcodeValue); // Define valid prefixes for Bin var validPrefixes = [ 'BTR75', 'BTR76', 'BTR780', 'BTR781', 'BTR7820', 'BTR7821', 'BTR7831', 'BTR7846', 'BTR7847', 'BTR7848', 'BTR7855', 'BTR7866', 'BTR789', 'BTR790', 'BTR792', 'BTR798' ]; var isValid = false; // Check if barcode is empty or not a text value if (IsEmpty(barcodeValue) || TypeOf(barcodeValue) != 'String') { Console('Failed: Empty or non-text'); isValid = false; } // Check if barcode starts with BTR and is 10 characters long else if (Left(barcodeValue, 3) != 'BTR' || Count(barcodeValue) != 10) { Console('Failed: Invalid format, BTR=' + Left(barcodeValue, 3) + ', Length=' + Text(Count(barcodeValue))); isValid = false; } // Check if barcode starts with any valid prefix else { for (var prefixIndex in validPrefixes) { var currentPrefix = validPrefixes[prefixIndex]; if (Left(barcodeValue, Count(currentPrefix)) == currentPrefix) { Console('Passed: Matched prefix ' + currentPrefix); isValid = true; break; } } } // Return validation result Console('Result: ' + Text(isValid)); return isValid;   ... View more