topic Re: Date Filters - Last Week in ArcGIS Experience Builder Questions

Date Filters - Last Week

JonathanMcDougall — Wed, 26 Jan 2022 16:32:10 GMT

I've report experience that I want to show/report data within the last week. Data for the report is run only on a Friday, covering Friday 5pm to following Friday at same time (inc weekends) and I don't want to lose the visibility of information as "7 days" pass, same for "1 week".

Is there an easy way, just to filter for "Date Last Week"?

Re: Date Filters - Last Week

RichlandGIS — Wed, 26 Jan 2022 19:35:35 GMT

Have you tried the expression builder in the filter widget?

It has a last week option:

Re: Date Filters - Last Week

JonathanMcDougall — Thu, 27 Jan 2022 00:47:58 GMT

Hi, thanks for the reply.

I should have perhaps been more specific - the last 1 week counts back 7 days from today and I'm also looking to have this filter used to create dynamic text.

eg; Number of objects created last week; 999 (filter being "Date is Last Week", a change of xxx.

So, last week one or even last 7 days moves forward with every new calendar day. A "is Last Week" option would "cement" the return to a set period.

Re: Date Filters - Last Week

RhettZufelt — Sat, 29 Jan 2022 00:17:24 GMT

One option would be to put an Arcade expression on the symbology in the web map and only have it draw the features with date of "Last Week".

Not sure how you would do the math to find the difference, but can easily make the map display only them.

var draw = Null; if (Year($feature.CreationDate) == Year(Now()) && Week($feature.CreationDate) == (Week(Now())-1)){ draw = "Yes"; } return draw

Quick test with the above Arcade (and turn off "other values" in symbology tab) will only draw data from last week.

Selects by week number, so put the year comparison in there so it doesn't grab everything from that "week" regardless of year.

Would have to modify it a little to handle the first week of the year (Week = 0) as some of it might get filtered out due to the year.