topic Re: Advanced formatting using Arcade in Dashboards in ArcGIS Online Questions

Advanced formatting using Arcade in Dashboards

AurelienJOSSET — Sun, 02 Apr 2023 20:37:01 GMT

Good morning,

I am trying to display in Dahboard via an indicator widget the sum of the Length shape of a layer by filtering such that the frequency is different from 0.

With the help of the community here is the expression:

var filter = Filter($layer, 'FREQ_MAINTENANCE <> 0');

var Sum = Sum(filter, 'Shape__Length');

return Sum;

However Dashboard with the advanced format, I'm forced to use $datapoint and I don't really see how to get out of it.

Which formula to put before the return

return {

//textColor:'',

//backgroundColor:'',

//topText: '',

//topTextColor: '',

//topTextOutlineColor: '',

//topTextMaxSize: 'medium',

middleText: $datapoint.sum_Shape__Length,

middleTextColor: '',

middleTextOutlineColor: '',

middleTextMaxSize: 'large',

//bottomText: '',

//bottomTextColor: '',

//bottomTextOutlineColor: '',

//bottomTextMaxSize: 'medium',

//iconName:'',

//iconAlign:'left',

//iconColor:'',

//iconOutlineColor:'',

//noValue:false,

//attributes: {

// attribute1: '',

// attribute2: ''

// }

}

After several reading of document, I did not succeed.

Also what is the difference between: $datapoint.field AND $datapoint.["field"]

Thanks for your help

Re: Advanced formatting using Arcade in Dashboards

JoshuaSharp-Heward — Mon, 03 Apr 2023 09:33:38 GMT

Hi Aurelian,

Unless I'm misunderstanding I think you might be over-complicating things. When adding the indicator widget you're able to add a filter (in this case FREQ_MAINTENANCE not equal 0) and choose the statistic as "SUM" on "Shape_Length".

Cheers,

Josh

Re: Advanced formatting using Arcade in Dashboards

AurelienJOSSET — Sat, 15 Apr 2023 20:35:15 GMT

Hi Josh.
My return is late, sorry. I finally figured out my problem. I also misspoke. In DashBoard if you want to work on a slightly complex data set (Layer A which intersects layer B for example) you have to create it via "Data expression".

We learn every day

Bye

Aurelian