topic Re: How to concatenate fields to show Graph... in ArcGIS Dashboards Questions

How to concatenate fields to show Graph...

MiltonSolano — Thu, 24 Mar 2022 21:19:09 GMT

Hi Folks,

I have this expression on my map popup window to show in one field, the content from 8 different fields (see screenshot below):

Trim(Concatenate([$feature["COD_A"],
$feature["COD_B"],
$feature["COD_D"],
$feature["COD_L"],
$feature["COD_M"],
$feature["COD_N"],
$feature["COD_P"],
$feature["COD_Q"],
$feature["COD_R"],
], ''))

I'm trying to create a graph on my dashboard to show exactly this expression (See the screenshot with the Pie Chart as example). The graph will show how many variations of the codes are in the database (ex. LR - 10, BQ-5, RB-2, D-15, etc.). The field expression is not available in Dashboards, so I can't use the expression. I tried Data Expressions but I can't figure out how to do it.

Can you help me to figure out how to achieve this? thanks in advance!

Milton

Re: How to concatenate fields to show Graph...

jcarlson — Thu, 24 Mar 2022 21:49:44 GMT

Data Expressions can be a lot to wrap your head around, but it's totally the way to go. This will allow you to create a "virtual" field in your data that a chart can interact with.

var fs = FeatureSetByPortalItem( Portal('your-portal-url'), 'itemid of feature service', 0, // or whatever the layer index ['*'], false ) // Get existing fields var fields = Schema(fs)['fields'] // Push new feature into field array Push( fields, {name: 'concat_vals', type: 'esriFieldTypeString'} ) // Create dictionary to hold output features var out_dict = { fields: fields, geometryType: '', features: [] } // Iterate over features, concatenating fields and pushing into feature array for (var f in fs){ // Get feature as dict var feat = Dictionary(Text(f)) // // Values to concatenate var concat_arr = [ f['COD_A'], f['COD_B'], f['COD_D'], f['COD_L'], f['COD_M'], f['COD_N'], f['COD_P'], f['COD_Q'], f['COD_R'] ] // // Concatenate values to string var concat_str = Trim(Concatenate(concat_arr, '')) // // Add concat field to feature dict feat['attributes']['concat_vals'] = concat_str Push( out_dict['features'], feat ) } // Return populated dict return FeatureSet(Text(out_dict))

I tested this against another layer, and it successfully returns a "concat_vals" field, which your chart would then be able to see.

Re: How to concatenate fields to show Graph...

MiltonSolano — Fri, 25 Mar 2022 14:47:09 GMT

Wonderful Josh,

it worked straight from the forum! Thank you for taking the time to help with this.

Milton