ArcGIS Dashboards Indicator Attribute Expression to Sum across fields with conditions

LJackson29

Hello - I am working in ArcGIS Online Dashboards. My dashboard already has a data expression to create some necessary fields with data at the feature level. I am trying to create an attribute expression for an indicator that sums data across 4 fields (A, B, C, and D below) selecting different features for each field depending upon a status field. Below is what I came up with, but it is not working. Any suggestions? TIA

 

var SUM_A=IIf($datapoint.status='Submitted', sum($datapoint.A),0)
var SUM_B=IIf($datapoint.status='Scored', sum($datapoint.B),0)
var SUM_C=IIf($datapoint.status='construction', sum($datapoint.C),0)
var SUM_D=IIf($datapoint.status='Complete', sum($datapoint.D),0)
var SUM_ABCD = SUM_A+SUM_B+SUM_C+SUM_D


return {
  //textColor:'',
  //backgroundColor:'',
  topText: 'Total Cost',
  //topTextColor: '',
  //topTextOutlineColor: '',
  //topTextMaxSize: 'medium',
  middleText: SUM_ABCD,
  middleTextColor: '',
  middleTextOutlineColor: '',
  middleTextMaxSize: 'large',
  //bottomText: '',
  //bottomTextColor: '',
  //bottomTextOutlineColor: '',
  //bottomTextMaxSize: 'medium',
  //iconName:'',
  //iconAlign:'left',
  //iconColor:'',
  //iconOutlineColor:'',
  //noValue:false,
  //attributes: {
    // attribute1: '',
    // attribute2: ''
  // }
}

  

DanielReynolds4

I'm not really sure if there is a way to aggregate values from multiple features. You may need to create a new data expression to summarize the data.