topic Arcade in pop up in ArcGIS Online Questions

Arcade in pop up

DEI — Wed, 20 Oct 2021 15:17:34 GMT

Hello,

Would anyone please be willing to share how to display quarterly inspection results in a pop up using Arcade? I’m at a loss. Below is an example of what I’ve tried so far:

var Q3E = Date(2021,09,01);

var Q3S = Date(2021,05,01);

var CD = FeatureSetByRelationshipName($feature,"InsTable",["InsDate"]);

var CR = IIF(CD < Q3E && CD >= Q3S, "InsRead", "No Data");

return CR;

Re: Arcade in pop up

jcarlson — Wed, 20 Oct 2021 15:38:12 GMT

In your expression, you're trying to filter the FeatureSet CD by dates. In order to do this, you need to actually use the Filter function.

var CR = Filter(CD, "InsDate < @Q3E AND InsDate >= @Q3S")

Note that this will still only return a FeatureSet. In order to access the attributes of individual features, you will need to use a for loop or some other function.

Can you give more details on what the popup ought to look like? Do you want summary statistics of the inspection results, a single attribute, a row per inspection? Other inspection fields? Right now, your inspections FeatureSet only includes the "InsDate" field, nothing else.

Re: Arcade in pop up

DEI — Wed, 20 Oct 2021 16:08:29 GMT

Thanks @jcarlson ,

I would like to display a single attribute for each quarter in the pop up. Something like this:

Where each expression returns the inspection result. My thought was if I could evaluate each point's inspection dates to see if any fall within a range (or quarter), I could then return the result that was recorded from that particular date. I hope that answers your questions. I appreciate your help!

Re: Arcade in pop up

jcarlson — Wed, 20 Oct 2021 16:32:43 GMT

Got it. So, assuming that you've only got one inspection per quarter, you could use the First function. Also, since you're wanting the inspection results in your output, we need to include that in the FeatureSet.

Thinking about it more, too, we can include some SQL in the Filter function to get the appropriate quarter without the need to create additional variables.

var CD = FeatureSetByRelationshipName($feature,"InsTable",["InsDate", "inspection-results-field"]); // Filter for certain months of 2021 var CR = Filter(CD, "InsDate < '09/01/2021' AND InsDate >= '05/01/2021'") if(Count(CR) > 0){ return First(CR)["inspection-results-field"] } else { return "No Data" }

Re: Arcade in pop up

DEI — Wed, 20 Oct 2021 17:35:06 GMT

@jcarlson you are brilliant!!

That worked perfectly - thank you much!