Dashboard Data Expression Survey Date List from All AGOL Survey Feature Layers for Category Selector

Question

Hello,

I am working on a dashboard with a category selector to show survey data by survey date. Instead of selecting just one data source in case no data was collected for that layer I would like to be able to set a data expression as the source, that way I do not miss showing survey data on the dashboard.

There are 5 survey data layers and I can pull in the dates as a FeatureDataset for each of the data layers (like below), but I'm having trouble combining all the data sources and to get a distinct survey date list. I'm not sure where to go after I get the individual layer dates.

Do I need to make a list from the FeatureDataset or please advise. I am not very versed in arcade.

var fs = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'xyz', 0, ["AKDate"], false);
var track_dt = Distinct(fs,["AKDate"]);

@XanderBakker you have been such a great help in the past, any suggestions on the arcade syntax? Thank-you!

Thanks in advance!

Kathy

kmsmikrud · Accepted Answer

Thanks to other posts on Community this code works! Might not be the most efficient but it works!

var fs = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'xyz', 0, ["AKDate"], false);
var track_dt = Distinct(fs,["AKDate"]);

var fs2 = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'xyz', 2, ["AKDate"], false);
var spawn_dt = Distinct(fs2, ["AKDate"]);

var fs3 = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'xyz', 1, ["AKDate"], false);
var pred_dt = Distinct(fs3, ["AKDate"]);
//return track_dt

var fs4 = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'xyz', 0, ["AKDate"], false);
var hschool_dt = Distinct(fs4, ["AKDate"]);

var Dict = {
    'fields':[
        {'name': 'AKDate', 'type': 'esriFieldTypeString'}
],
'geometryType': '',
'features':[]
};

for (var f in pred_dt){
    Dict.features[i] = {
        'attributes':{
            'AKDate': f['AKDate'],
        }
    };
    i++;
}

for (var f in hschool_dt){
    Dict.features[i] = {
        'attributes':{
            'AKDate': f['AKDate'],
        }
    };
    i++;
}

Console(Text(Dict))
var s_dt = FeatureSet(Text(Dict));
return Distinct(s_dt,['AKDate']);