topic Re: Cannot select a date field as Category in Chart widget in ArcGIS Experience Builder Questions

Cannot select a date field as Category in Chart widget

JimmyWanHK — Tue, 26 Mar 2024 02:26:25 GMT

Hello, I am using the experience builder version 1.13 and I am using the Chart widget to create a line chart for the rainfall data (rainfall data over time). The rainfall data is just a table consisting of a date field (timestamp) and a double field for the rainfall value.

And I would like to select a date field as Category in Chart, but I couldn't select the date field.

When I was investigating the issue, I found that there is an error when requesting the MapServer..

It will throw error when I input below value in "Output Statistics"
"[{"onStatisticField":"TIMESTAMP","outStatisticFieldName":"MIN","statisticType":"min"},{"onStatisticField":"TIMESTAMP","outStatisticFieldName":"MAX","statisticType":"max"},{"onStatisticField":"OBJECTID","outStatisticFieldName":"COUNT","statisticType":"count"}]"

Any ideas how to solve this issue? Thanks a lot!

Re: Cannot select a date field as Category in Chart widget

JimmyWanHK — Tue, 26 Mar 2024 02:36:06 GMT

My experience builder version is 1.13, and the ArcGIS Enterprise version is 10.9.1. I am wondering whether it is not compatible ..

Re: Cannot select a date field as Category in Chart widget

Wei_Ying — Thu, 29 Aug 2024 00:35:55 GMT

Hi @JimmyWanHK ,

Thanks for your feedback!
It looks weird and we have not yet get similar feedback. Could you try clear browser cache and refresh the app to reconfigure the Chart?
Dev edition 1.13 support date category and portal version where the data service is from should not matter.

Re: Cannot select a date field as Category in Chart widget

IDT_tinghuahuang — Fri, 23 Aug 2024 07:19:08 GMT

I got the same problem. It only happen if the data is set to "Selected Features". I am using experience builder 1.14 with ArcGIS Enterprise 11.1.

Re: Cannot select a date field as Category in Chart widget

KelseyMills — Fri, 12 Sep 2025 19:53:42 GMT

This seems to still be a problem in Enterprise 11.4, Experience Builder 1.15. Category field cannot be a date/time field if the data is set on Selected Features. I can confirm that clearing browser cache does not fix the problem

Re: Cannot select a date field as Category in Chart widget

Wei_Ying — Tue, 18 Nov 2025 19:15:55 GMT

General Date field has been supported as category field in chart since 11.2. But date-only and time-only date field have not been supported yet.

Re: Cannot select a date field as Category in Chart widget

Alison_Mynsberge — Thu, 05 Feb 2026 17:41:31 GMT

It isn't working for line charts. It does work for bar charts. We're in 11.3 Enterprise. The bug may have been partially fixed at 11.2, but it isn't fully functional at 11.3.

Re: Cannot select a date field as Category in Chart widget

Alison_Mynsberge — Thu, 05 Feb 2026 17:42:53 GMT

BUG-000161410 should be tagged with a related bug that reflects the nuance. It should be possible to have a 2-series chart with dates on the X axis and values for 2 fields on the Y axis.

Re: Cannot select a date field as Category in Chart widget

Wei_Ying — Wed, 04 Mar 2026 05:08:13 GMT

line chart does support multi series. Maybe I get it wrong.
You can choose 2 number fields for the 2 series, with the same X-axis

Re: Cannot select a date field as Category in Chart widget

JeffLegato1 — Tue, 28 Apr 2026 17:12:47 GMT

Confirming I'm seeing the same thing at 11.3. Bar chart works but line chart doesn't.