Arcade Data expression on a dashboard indicator to match and filter two layers based on date fields (range)

Question

Hi all

Let me please explain what I am trying to do briefly.

I have two feature sets; one hosted table showing tide values in 10 minutes interval (date field and tide field), and one hosted feature layer showing vessel berths with ETA and ETD fields among others.

I was tasked with creating a dashboard to check if the tide values are within the accepted range during the berthing. So dashboard should display minimum available tide when a specific berthing is selected.

Best solution would be to display required value on an indicator and minimum tide value available from the tide chart as a reference value. But since this is a range, I cannot do this automatically. I think the solution lies in arcade data expressions.

My hypothetical solution is to create a variable which filters the tide table based on the ETA -ETD interval and then minimum value can be displayed easily on the indicator as a statistic later on. Of course this ETA - ETD value should be specific to each berthing.

Since I have limited time for this particular task, and limited knowledge with arcade, I appreciate any help.

Am I one the right track? If so could you please help me with the arcade data expression?

Many thanks

Kivanc

KIVANC · Answer

Thanks David. I think I confused myself with it, you are right. I will explore more when I have the time.

DavidPike · Answer

I don't quite get what you mean.  Filter() would be used against the entire FeatureSet in that case which doesn't make sense.

I think you might be missing what the Data Expression is, it returns a FeatureSet which you then can filter using category/date selectors - filtering within the Indicator widget/dashboard element isn't logical (to me at least).

KIVANC · Answer

Hi David

Many thanks for your reply.

I thought it would be easier for me to keep it simple in arcade by leaving the selection of the min value to the indicator widget rather than finding in the expression.

After bringing in both layers is it possible to use filter function and somehow make use of those layers?

var Tide = .......

var Berth = ....... //has ETA and ETD//

var TideFiltered = // filter expression that removes features from the tide having dates <ETA and >ETD //

Then on widget I can say statistics - minimum to the reference section.