topic Re: Dashboard query range among years in ArcGIS Dashboards Questions

Dashboard query range among years

RoseZhou2 — Wed, 25 Aug 2021 16:05:39 GMT

Hello,

Is there any way to do range among years query in ArcGIS Dashboards? For example, we have multiple years data. We want to query data from Aug. 1st to Aug 10th of year 2019, 2020 and 2021. If not, any workarounds?

Thanks in advance!

Rose

Re: Dashboard query range among years

jcarlson — Wed, 25 Aug 2021 16:56:28 GMT

To interactively slice a date range across multiple years, you'd essentially need separate fields representing parts of the date (month, day, or maybe a single day of year, i.e 237 for Aug 1), or else you'd need to carefully define that as an option in your Date Selector.

The latter option can be extremely tedious with many ranges, and is not adjustable for the dashboard's users. If you edit the dashboard's JSON, you can quickly create lots of defined options, but the static nature of those selectors may not be what you want.

Re: Dashboard query range among years

RoseZhou2 — Wed, 25 Aug 2021 17:22:53 GMT

Thanks Josh for your insight!

Yes, the latter one is not an option for me as it's not adjustable for the dashboard's users.

We do have a field "yDay" which represents a single day of the year, for example120 for Apr. 30th, 2021. With that, how to interactively slice a date range across multiple years? Any more detailed information? Or can you point me to any document?

Thanks so much!

Rose

Re: Dashboard query range among years

jcarlson — Wed, 25 Aug 2021 17:38:39 GMT

I believe you'd need a "year" field, too, thinking about it more. Easy enough to calculate that to a new field using EXTRACT. The day and year would each have to be on their own number / category selectors.

Re: Dashboard query range among years

RoseZhou2 — Wed, 25 Aug 2021 17:56:06 GMT

Thanks again Josh,

You are right that the day and year would each have to be on their own number selector. For the day number selector, it will display from 1 to 365. That is not user friendly. Instead of displaying 1 to 365, is there a way to display Jan. 1 to Dec. 31 like the screenshot below?

Thanks

Rose

Re: Dashboard query range among years

jcarlson — Wed, 25 Aug 2021 17:58:51 GMT

Could you add a coded domain to the field to associate each number with its label? I'm not sure of another way.

Re: Dashboard query range among years

RoseZhou2 — Mon, 30 Aug 2021 14:54:51 GMT

Thanks Josh,

I tried to used a coded domain, but that did not work. The "Number Selector" only shows the numbers, not the coded values.

Regards

Rose