topic Re: Group by date in Table in ArcGIS Dashboards Questions

Group by date in Table

MarkCooper5 — Thu, 07 Mar 2024 13:22:24 GMT

I have a serial chart showing number of calls received by month. This groups on date and is set to have a minimum period of 1 month. I would like to add the same information in table form. However, for some reason you cannot group by a date field (and therefore not have the minimum period of 1 month). It seems very strange as the technology can obviously do this as it can create the graph. I just need it in table form.

Does anyone know if there is a work around for this as it is vital that customers can see the table as well as the graph.

Thanks

Re: Group by date in Table

jcarlson — Thu, 07 Mar 2024 16:24:15 GMT

One way around this limitation is to use a Data Expression. You can group your data by month in your expression, then return the result as its own data source. In this scenario, you'd have the table set to "features", not "grouped valued", since the grouping happens in the expression.

Re: Group by date in Table

MarkCooper5 — Thu, 07 Mar 2024 16:27:41 GMT

Thank you - I will have to look into that. I presume that will require some knowledge of arcade?

I just can understand why they have missed this feature out. If I download the summaries data, it immediately creates the exact table I want!!