Concatenate fields in dashboard data expression

SFM_TravisBott

I'm having trouble with the workflow and syntax for data expressions in a dashboard. I have two fields and I would like to be able to create dashboard elements from a concatenation of those two fields. Both fields are text and have domains. 

I understand the basics to create a pop-up or labels from this concatenation in Arcade, but do not see how to translate that into a feature set/data expression. 

Basic concatenation: 

Concatenate([$feature["Field_1"], $feature["Field_2"]], ' ')

 

To start setting up the data expression...

// Set variables
var portal = Portal('https://MyPortral.maps.arcgis.com/');
var itemId = 'itemId';
var layerId = 0;

var fs = FeatureSetByPortalItem(portal, itemId, layerId, ['*'], false);

 

....and now what is the appropriate workflow?  Attempt to call fields and concatenate/count? Generate a dictionary of concatenated values and count? Documentation seems pretty skinny as this is fairly new. 

VivekMalleshappa

Hi @SFM_TravisBott 

Here's are two options for concatenating strings in data expressions: 

Option 1: In the Arcade GroupBy() function by specifying the SQL CONCAT() function to create a string in the group by field: 

 

 

var fs = FeatureSetByPortalItem(Portal('https://arcgis.com'),'07945c22c9bc497f9489f97e6203de3c',0,['Division', 'Battalion'], false)

var concatExpr = "CONCAT(Division, ', Division ', Battalion)"
return GroupBy(fs, [concatExpr], [ {name: 'Total', expression: 'DispatchTimeSecs', statistic: 'Average' }])

 

Option 2: Using Arcade's Concatenate() function: 

 

var fs = FeatureSetByPortalItem(Portal('https://arcgis.com'),'07945c22c9bc497f9489f97e6203de3c',0,['Address', 'City', 'Problem'], false)

// Dictionary to hold concatenated strings.
var concatDict = {
    'fields': 
        [{ 'name': 'concat_str', 
           'type': 'esriFieldTypeString'
        }, 
        { 'name': 'problem', 
           'type': 'esriFieldTypeString'
        }], 
        'geometryType': '', 'features': []}; 
                   
var index = 0; 

// Concatenate Address and City fields for each feature.   
for (var feature in fs) { 
    concatDict.features[index++] = { 
            'attributes': { 
                'concat_str': Concatenate(feature['Address'],', ', feature['City']), 
                'problem': feature['Problem']
            }
} }

// Return dictionary as a featureSet. 
return FeatureSet(Text(concatDict)); 

 

The first option allows you created group by statistics on concatenated fields. The second options allows you retain feature level data, in case collapsing data by groups is not intended. 

Hope this helps! If there are specific use cases or additional documentation you think could help, please let us know.