Advanced formatting using Arcade in Dashboards

Question

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

AurelienJOSSET · Answer

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

JoshuaSharp-Heward · Answer

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