topic Arcade Data Expression in ArcGIS Dashboards Questions

Arcade Data Expression

Kristofer — Thu, 06 Jul 2023 12:00:12 GMT

Hi All,

I want to get the current time data using Data Expression.

In my feature layer having the data of (future as well as historic) current time and for the next two days on hourly basis i.e. 2:30 PM, 3:30 PM, I want to get the data which is related to current hour is running.

Let's suppose now time is 6:40AM. only push the feature which is coming under that time.

Regards,

Sunita

Re: Arcade Data Expression

JakeSkinner — Thu, 06 Jul 2023 14:34:41 GMT

Hi @Kristofer ,

See the following document, it shows how to create a dynamic date filter with arcade.

Re: Arcade Data Expression

Kristofer — Thu, 06 Jul 2023 15:45:03 GMT

Hi @JakeSkinner

I want to filter the data only for tomorrow from 12:00 am to 11:59 pm. I tried to using json editor also.

time BETWEEN timestamp(CURRENT_DATE (), +1, 'day') AND timestamp(CURRENT_DATE (), +1, 'day')

also wanted to another filter the data from tomorrow day after.

Could you please help me on this.

Regards,

Sunita

Re: Arcade Data Expression

Kristofer — Thu, 06 Jul 2023 19:13:40 GMT

Hi @JakeSkinner

I wanted to Data expression code but you have shared the documentation for pop-up.

Thanks for the response.

Re: Arcade Data Expression

JakeSkinner — Fri, 07 Jul 2023 00:35:19 GMT

@Kristofer ,

Try the following:

var year = Year(Now()); var month = Month(Now()); var day = Day(Now()) + 1; var hour1 = 00; var minute1 = 00; var second1 = 00; var hour2 = 23; var minute2 = 59; var second2 = 59; var dateField = $feature.duedate; var tomorrowDate1 = Date(year, month, day, hour1, minute1, second1) var tomorrowDate2 = Date(year, month, day, hour2, minute2, second2) IIf(dateField > tomorrowDate1 && dateField < tomorrowDate2, 'future', 'past');