topic Re: Grouping dates in a serial chart using a data expression in ArcGIS Dashboards Questions

Grouping dates in a serial chart using a data expression

SWatterson-CALFIRE — Mon, 08 Aug 2022 16:27:20 GMT

I have a large table of inspections (a layer in a feature service) that includes a date field ('Inspections_date'; example format: 7/11/2022 2:23:00 PM) and spans several years. I would like to create a serial chart that groups the inspections by month and has two or more series to compare years. A simple excel chart looks like the attached (line chart works too). I know that using a data expression can probably get me there, but 1) I'm fairly new working with Arcade and 2) I can't figure out how to group by the date field to parse out the month. I'm also wondering if I should do some of this work in the feature service (grouping by month) instead of in Dashboard. Any guidance would be much appreciated!

Re: Grouping dates in a serial chart using a data expression

SWatterson-CALFIRE — Tue, 09 Aug 2022 20:04:48 GMT

Using a similar post/thread I was able to create what I think is pretty close to what I need. However, I'm receiving a "failed to fetch" error when I test it.

Re: Grouping dates in a serial chart using a data expression

StephenKaranja — Fri, 13 Dec 2024 14:04:14 GMT

You have an error in your code. The Portal() function is being called twice in line 1 and line 7. The following line (line 7) should not have the Portal() function. It should simply have p as the first parameter.

var fs = FeatureSetByPortalItem(p, itemId, layerId, fields, false);