Hello folks,
I am trying to get the total of three fields to display on an Dashboard Indicator , Table or Gauge
the layer where the fields are located is called:
TBM Internal Planning - Sewer Capacity-CWWTP
Looking for the Gauge/ Indicator/ table to show something like this:
CanCoonect 1614
Reserved 3193
DesPro 1679
Total 6486
All would be ideal ... just the total would be fine too..
Here is my expression so far.... any suggestions...? this expression seemed to work in a popup but no luck in dashboard
FYI - I'm pretty new to Arcade -
var Canc = Sum(fs, "S_CanConne_");
var Reserved = Sum(fs, "S_Reserved");
var DeswPro = Sum(fs, "S_DesWpro");
var Total = Canc + Reserved + DeswPro;
// structure the result
var result = "CanConnect: " + CanC;
result += TextFormatting.NewLine + "Reserved: " + Reserved;
result += TextFormatting.NewLine + "DeswPro: " + Deswpro;
result += TextFormatting.NewLine + "Total: " + Total;
// return the result
return result;
