Dashboard expression to calculate total of 3 separate fields

aroininen

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;

 

kenbuja

First, if you're going to post code, please use the Insert/Edit code sample button. That makes it easier to read the code and copy it to test it.

Second, you haven't created the FeatureSet fs to get your sums.

Third, a data expression has to return a FeatureSet to be used in a indicator, table, or gauge. To show the total of the sums in an indicator, you could use this return (using the rest of your code)

return FeatureSet(
  {
    fields: [{ alias: "Total", name: "Total", type: "esriFieldTypeInteger" }],
    features: [{ attributes: { Total: total } }]
  }
);

You could create a table with this return

return FeatureSet(
  {
    fields: [
      { alias: "Can Connect", name: "CanConnect", type: "esriFieldTypeInteger" },
      { alias: "Reserved", name: "Reserved", type: "esriFieldTypeInteger" },
      { alias: "DeswPro", name: "DeswPro", type: "esriFieldTypeInteger" },
      { alias: "Total", name: "Total", type: "esriFieldTypeInteger" }
    ],
    features: [
      {
        attributes:
          {
            CanConnect: CanC,
            Reserved: Reserved,
            DeswPro: DeswPro,
            Total: total
          }
      }
    ]
  }
);