ARCADE Groups BY Function

MOGOMAINTERNE — Thu, 02 Feb 2023 20:57:48 GMT

Hello,

In AGOL, I want to return a result with a loop (contextual window) depending on the value present in a field. I'm a beginner with ARCADE and I can't do what I want

My ARCADE expression is:

// Acess 'Groundwater Levels Monthly Mean' table as a FeatureSet
var portal = Portal("https://www.arcgis.com")
var waterLevels = FeatureSetByPortalItem(portal,
"2700a42fce724cd588477fd60f1d84c1", 1, ['Commande', 'Etat_Pose',
'Ref_Gravee', 'Num_poteau', 'Ligne','Texte', 'Altitude', 'Longueur','Tps_pedestre', 'Altitude', 'Sens'])

// Filter related features by using a common attribute
var NUM_ENTITE = $feature["NUM_ENTITE"]
var filterStatement = 'Num_poteau = @NUM_ENTITE'

// Related features as a variable
var relatedData = Filter(waterLevels, filterStatement)

// Sort related features by oldest to newest
var relatedDataSorted = OrderBy(relatedData, 'Ref_Gravee')

// Build the pop-up string by iterating through all related features
var popupString = ''
for (var f in relatedDataSorted){

popupString += f.Ref_Gravee + TextFormatting.NewLine +

f.Commande + f.Texte + f.Longueur + TextFormatting.NewLine

}

DefaultValue(popupString, 'No measurements to show')

My result :

38206_048_A
AucuneLaval - Château
38206_048_B
A commander 2022 - 07LAVAL - Mairie0.4 km
38206_048_B
A commander 2022 - 07Laval - Église0.3 km
38206_048_C1
Commande N°03 2021LES ADRETS5.4 km
38206_048_C1
Commande N°03 2021COL DU LAUTARET4.3 km
38206_048_C2
Commande N°03 2021LES CRÊTS2.4 km
38206_048_C2
Commande N°03 2021TOUR DE MONTFALLET0.6 km
38206_048_D
AucuneLE CHAMP PRES FROGES3.3 km
38206_048_D
AucuneFROGES3.3 km
38206_048_D
AucuneCôtes Rousses0.8 km

What I want: to group my result according to the 'Ref_Gravee' field. I tried with GROUP BY and FOR IN but I can't.

38206_048_A
AucuneLaval - Château

38206_048_B
A commander 2022 - 07LAVAL - Mairie0.4 km
A commander 2022 - 07Laval - Église0.3 km

38206_048_C1
Commande N°03 2021LES ADRETS5.4 km
Commande N°03 2021COL DU LAUTARET4.3 km

38206_048_C2
Commande N°03 2021LES CRÊTS2.4 km
Commande N°03 2021TOUR DE MONTFALLET0.6 km

38206_048_D
AucuneLE CHAMP PRES FROGES3.3 km
AucuneFROGES3.3 km
AucuneCôtes Rousses0.8 km

Thanks a lot for your help
Do not hesitate if you need clarification

Aurélien

topic ARCADE Groups BY Function in ArcGIS Online Questions

ARCADE Groups BY Function