Help with Data Expression for Table Widget in ArcGIS Dashboard

GeoGeek

I'm seeking assistance with creating data expression for a table widget in ArcGIS Dashboard. I've been experimenting but haven't been able to achieve the desired outcome.

Here is my sample data:

Sample data

Only two fields are involved.

Here is the desired result:

Desired outcome in table widget

I've tried using Arcade expressions, but I'm unsure how to structure it.

Any guidance, examples, or resources would be greatly appreciated. 

kenbuja

Good use of the Case statement in the GroupBy function. I always overlook that as a possible solution.

I believe you'll still have to loop through the grouped Featureset to calculate the percentage. 

var investigated = "CASE WHEN Status = 'Investigated'   THEN 1 ELSE 0 END";
var pending = "CASE WHEN Status = 'Pending'           THEN 1 ELSE 0 END";

var grouped = Groupby(
  fs,
  ["Person"],
  [
    { name: "Total", expression: "Status", statistic: "COUNT" },
    { name: "Investigated", expression: investigated, statistic: "SUM" },
    { name: "Pending", expression: pending, statistic: "SUM" }
  ]
);

var fields = Schema(grouped).fields;
Push(fields, { name: "Percentage", type: "esriFieldTypeDouble" });
var features = [];
for (var g in grouped) {
  push(
    features,
    {
      attributes:
        {
          Total: g.Total,
          Investigated: g.Investigated,
          Pending: g.Pending,
          Percentage: Round(g.Investigated / g.Total * 100)
        }
    }
  );
}
return FeatureSet({ fields: fields, features: features });