Arcade in Dashboards

aroininen

Hello there!

is it possible to display an arcade expression like the example below in one of the ArcOnline Dashboard items?  Indicator , Items , Details or Rich Text?

basically I would like to display summarized data on a dashboard - charts and graphs work but not ideal - just want to display the values

 

var sql = "ServiceAre_1 IN (2,5,6,8,9)";
var fs = Filter ($layer,sql);

 

var CanC = sum(fs, "F_CanConne_1");
var Reserved = sum(fs, "F_Reserved_1");
var DeswPro = sum(fs, "F_Des_Wpro_1");
var Total = Canc + Reserved + DeswPro;

var result = "CanConnect: " + CanC;
result += TextFormatting.NewLine + "Reserved: " + Reserved;
result += TextFormatting.NewLine + "DeswPro: " + DeswPro;
result += TextFormatting.NewLine + "Total: " + Total;

return result;

Result:

CanConnect: 317

Reserved: 27

DeswPro: 0

Total: 344

end result something like this?

 

DavidPike

I guess you'd use the indicator, but to be honest it's something I would trial and error myself.

You should also understand that the data expression is not simple without prior knowledge of how it works, I'd recommend fully reading the documentation and code samples on how to construct the return featureSet (the data expression only returns a featureSet, not a value or string etc.)

The simplest way I can think of getting your itemID is to co to your content page, click on your hosted feature layer and you will see the itemID in the url.

var fsbpi = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'ItemIDd10b9e8dbd7f4cccbd0a938a06c586e9' , 0, ['field or list of fields'], false)
var sql = "ServiceAre_1 IN (2,5,6,8,9)";
var fs = Filter (fsbpi,sql);

 
var CanC = sum(fs, "F_CanConne_1");
var Reserved = sum(fs, "F_Reserved_1");
var DeswPro = sum(fs, "F_Des_Wpro_1");
var Total = Canc + Reserved + DeswPro;

//then construct a new featureSet from CanC, Reserved....