Dynamic Fiscal Year Filter

bsklaohfl — Thu, 30 Mar 2023 13:59:54 GMT

Hi,

I am in need of a way to display a dynamically changing Fiscal Year data parameter. Each Fiscal Year begins 10/01 and ends the follow year on 09/30. The data would change based on the current Fiscal Year.

I have accomplished this on the Map Viewer using an Arcade expression for symbology, which is attached. Is there a way to translate this using a widget on the Experience Builder? I have tried using the Query SQL Expression Builder but have found it limiting...unless I am using it wrong.

Thanks in advance.

if ($feature["DateTimeInit"] >= Date(2019, 10, 1) && $feature["DateTimeInit"] <= Date(2020, 9, 30)) { return 'FY 20'; } else if ($feature["DateTimeInit"] >= Date(2020, 10, 1) && $feature["DateTimeInit"] <= Date(2021, 9, 30)) { return 'FY 21'; } else if ($feature["DateTimeInit"] >= Date(2021, 10, 1) && $feature["DateTimeInit"] <= Date(2022, 9, 30)) { return 'FY 22'; } else { return 'N/A'; }

Re: Dynamic Fiscal Year Filter

ShengdiZhang — Fri, 27 Jun 2025 07:40:20 GMT

Hi @bsklaohfl ,

Arcade is supported in Experience Builder in the June 2025 AGOL release.

However, due to some limitations, Arcade fields are not currently supported. As a workaround, you can use a list widget and add Arcade expressions to the text widget of a list.

Regards,

Shengdi

topic Re: Dynamic Fiscal Year Filter in ArcGIS Experience Builder Questions

Dynamic Fiscal Year Filter

Re: Dynamic Fiscal Year Filter