Dashboard Data Expression to Combine Layer & Related Table Fields

ZoeTysonLID1989

Hi! I am trying to create a serial chart in Dashboards using data from a feature layer and its related table. I have one field in the feature layer that is basically the status (or "install") of a trap and then each of those individual records can have multiple related records with "actions." Basically, I need to be able to make a field with every trap "install" and every "action" without the actions overwriting the "install" status. I am trying to create a chart that shows the number of "installs" and the number of "actions" as different bars on a graph. 

My assumption is that I can do this somehow using Groupby or a dictionary in the data expression function, but I have not been able to figure it out. At the moment I have the script below, but it doesn't recognize "monitoraction" which is the field in the related table. I am sure there are also a host of other issues. Any input would be great; I have very little experience with Arcade!

var portal = Portal('https://www.arcgis.com');

// Layer
var fs = FeatureSetByPortalItem(
    portal,
    '452bb162c4e84671be55c31b02d2211e',
    0, 
    [
        'status',
        'monitoraction'
    ],
    false
);

// List of installs/monitors per field per feature; 
var out_dict = {
    fields: [{name: 'status', type: 'esriFieldTypeString'}],
    geometryType: '',
    features: []
}

// Iterate over each feature in the layer
for (var f in fs){
    
    Push(
        out_dict['features'],
        {attributes: {status: f['status']}}
    )
    
    Push (
        out_dict['features'],
        {attributes: {status: f['monitoraction']}}
    )
}

// Return populated out_dict as FeatureSet
return FeatureSet(Text(out_dict))

 

RPGIS

Your on the right track. The only thing you would need to do is set the FeatureSetByPortalItem for both feature and table and then create the featureset using values from both.