nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need Help Writing an Arcade script for Expression for Serial Chart

BrianHartz_Lumos

I'm working on developing a dashboard for high level people within our organization. Currently, we have a field (RoadCL_FT) that is a Double data type field. I need to write an Arcade script that will allow me to add 30% to all the records in that field. Any suggestions?

Find more posts tagged with

ArcGIS Online

Accepted answers

kenbuja

You can use the GroupBy function to add 30% to a field. Here's an example from the Playground

// Fetches features from a public portal item
var fs = FeatureSetByPortalItem(
  Portal("https://www.arcgis.com"),
  // portal item id
  "6200db0b80de4341ae8ee2b62d606e67",
  0, // layer id
  ["*"], // fields to include
  true // include or exclude geometry
);

GroupBy(fs, 'BUILDINGID', [{ name: 'Base Elevation', expression: 'BASEELEV', statistic: 'MAX' },
  { name: 'New Base Elevation', expression: 'BASEELEV * 1.3', statistic: 'MAX' }])

All comments

BrianHartz_Lumos

I had to make a couple of adjustments to what you sent me, but it was what I needed to achieve the goal. Thank you for the assist!!

BrianHartz_Lumos

Then layer that I'm trying to work with is a layer that is in a group layer or dataset. Would I plug in the ID of the group then try to limit it to the layer name?

kenbuja

No, you don't need to. The GroupBy function creates the new FeatureSet that you can use in your serial chart. In the code above, I added as the output both the original field and the calculated field with the 30% added, but just to compare the field. You could just include the calculated field without the original field.

BrianHartz_Lumos

Do I need to create a new field for the data to be populated in?

kenbuja

You can use the GroupBy function to add 30% to a field. Here's an example from the Playground

// Fetches features from a public portal item
var fs = FeatureSetByPortalItem(
  Portal("https://www.arcgis.com"),
  // portal item id
  "6200db0b80de4341ae8ee2b62d606e67",
  0, // layer id
  ["*"], // fields to include
  true // include or exclude geometry
);

GroupBy(fs, 'BUILDINGID', [{ name: 'Base Elevation', expression: 'BASEELEV', statistic: 'MAX' },
  { name: 'New Base Elevation', expression: 'BASEELEV * 1.3', statistic: 'MAX' }])

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.