Latest Contributions by KenBuja

Can you post this as code instead of an image? It's easier to do checking when we can copy the code to the Playground ... View more

Use the When function instead of the ternary operator var borough = $feature['BoroughCode']; When(borough == "M", 'Manhattan', borough == "X", 'Bronx', borough == "B", 'Brooklyn', borough == "Q", 'Queens', borough == "S", 'Staten Island', 'n/a')   ... View more

You can use Arcade to conditionally show text. Read through that blog and other articles (their links are at the bottom) about how to use it ... View more

No, you don't need to. The GroupBy function creates the new FeatureSet that you can use in your serial chart. In the code above, I added as the output both the original field and the calculated field with the 30% added, but just to compare the field. You could just include the calculated field without the original field. ... View more

This shows the chart with your values using an Arcade element // Access related table var portal = Portal("https://www.arcgis.com") var relatedTable = FeatureSetByPortalItem(portal, "558cb226d1cd403c9e9bfc5dacd8ea67", 1, ['station_id', 'record_date', 'E__coli']) var station_id = Text($feature.station_id) var relatedData = Filter(relatedTable, "station_id = @station_id") // If no related records exist, return null if (Count(relatedData) == 0) { return null } // Sort records by date (ascending) var sortedData = OrderBy(relatedData, 'record_date ASC') // Prepare lists for charting var dates = [] var ecoliValues = {} //var chartColors = [] //use this to have a monocolor chart for (var f in sortedData) { // Convert date and E. coli values to the correct format var formattedDate = Text(Date(f.record_date), 'MM/DD/YYYY') var ecoliValue = Number(f.E__coli) if (!IsEmpty(formattedDate) && !IsEmpty(ecoliValue)) { Push(dates, formattedDate) //Push(ecoliValues, ecoliValue) ecoliValues[formattedDate] = ecoliValue // Push(chartColors, [6,47,120]) } } return { type: 'media', title : 'Events per Decade', description : 'Chart showing total events per decade', attributes : ecoliValues, mediaInfos: [{ type : 'columnchart', //linechart | barchart | piechart | columnchart altText : 'bar chart showing events per decade', //altText will be read by screen readers value : { fields: dates, // colors: chartColors } }] } ... View more

@JeffreyThompson2Where is this documented? ... View more

Unlike the Dashboard example you have in your initial question, the map doesn't get the color information from the Arcade expression for the symbology. It just gets the unique categories. For example, I have a map where I use an expression to classify the points based on the type of survey it is and whether it's been completed. if ($feature.TYPE == "PRIMARY") { if ($feature.SURVEY == "FISH & BENTHIC") { if ($feature.BenthicStatus == 0 && $feature.FishStatus == 0) { return "Fish and Benthics"; } } else if ($feature.SURVEY == "FISH ONLY") { if ($feature.FishStatus == 0) { return "Fish Only"; } } } else if ($feature.TYPE == "SECONDARY") { return "Secondary Site"; } Then I go into the "Pick a style" section of the Styles dialog to select the symbol shape, color, outline, etc for each category. Note that if the attributes of the feature change, its symbololgy will be automatically updated according to your expression.    ... View more

You use Arcade to set the outputs ("Active", "Inactive", "Failed", etc), but then you have to set the colors in the Styles dialog. ... View more

Yes, you'll need the Filter function to get the proper record. Use the proper field names for the common fields linking the table to the FeatureSet in lines 1 and 3. var asset = $feature.thecommonfield var LotData= FeatureSetByName($datastore,"ParkingLots", ['*'], false) var record = First(Filter(LotData, "thecommonfield = @asset) if (IsEmpty(record)) return "No Record Found" return record['lot_name']   ... View more