Dashboard examples using data with relationships/related tables?

Tiff

I'm curious of if anyone has examples of dashboards they've built or come across that use relationships/related tables. I have one or two of my own, but I have found that related tables come with limitations for filters, map interactivity, etc. and I want to better understand use cases and examples of deliverables using data with relationships to make decisions on data management for our projects.

Other apps like Experience Builder work too!

Thanks for sharing!

MosquitoGIS

Edited:  Just kidding, I got too excited!  This wouldn't work, as it doesn't tie their relationships back to the original Layer.  It just merges the two layers together.  But this is how you would at least do that.  I am not sure how to do the relate part. 😅 


As for the Arcade way, here is example code for me combining two separate layers together to appear as one in one of my dashboard. The code definitely could be cleaned up, but gets the point across. We have a fish and horse program that are of the same crew, but have different recording layers.  The dashboard needs to display them as if they are the same though.  So this combines them via arcade to look like one layer.

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

var Fish = FeatureSetByPortalItem(
    portallink,
    'Your Item ID Number',
    YourSubLayerNumber,
    [
        'Date_',
        'Employee',
        'Date2',
        'Employe2',
        'BoundLocat',
        'Status',
        'EditDate',
        'Editor'
    ],
    false
);

var Horse = FeatureSetByPortalItem(
    portallink,
    'Your Item ID Number',
    YourSubLayerNumber,
    [
        'Date_',
        'EMPLOYEE_I',
        'DATE_2',
        'Employee_2',
        'BoundLocat',
        'Status',
        'EditDate',
        'Editor'
    ],
    false
);

var features = [];
var feat;

for (var F1 in Fish) {
    feat = {
        attributes: {
            Date_: F1['Date_'],
            Employee: F1['Employee'],
            Date2: F1['Date2'],
            Employe2: F1['Employe2'],
            City: F1['Boundlocat'],
            Status: F1['Status'],
            EditDate: F1['EditDate'],
            Editor: F1['Editor'],
        },
    };
    Push(features, feat);
}

for (var F2 in Horse) {
    feat = {
        attributes: {
            Date_: F2['Date_'],
            Employee: F2['EMPLOYEE_I'],
            Date2: F2['DATE_2'],
            Employe2: F2['Employee_2'],
            City: F2['Boundlocat'],
            Status: F2['Status'],
            EditDate: F2['EditDate'],
            Editor: F2['Editor'],
        },
    };
    Push(features, feat);
}

var combinedDict = {
    fields: [
        { name: 'Date_', type: 'esriFieldTypeDate' },
        { name: 'Employee', type: 'esriFieldTypeString' },
        { name: 'Date2', type: 'esriFieldTypeDate' },
        { name: 'Employe2', type: 'esriFieldTypeString' },
        { name: 'City', type: 'esriFieldTypeString' },
        { name: 'Status', type: 'esriFieldTypeString' },
        { name: 'EditDate', type: 'esriFieldTypeDate' },
        { name: 'Editor', type: 'esriFieldTypeString' },
    ],
    geometryType: '',
    features: features,
};

return FeatureSet(combinedDict);