Cannot select a date field as Category in Chart widget

[JimmyWanHK]

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!

[JimmyWanHK]

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

[Wei_Ying]

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. 

[KelseyMills]

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

[IDT_tinghuahuang]

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.

[Wei_Ying]

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. 

[Alison_Mynsberge]

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.

[JeffLegato1]

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

[Alison_Mynsberge]

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.

[Wei_Ying]

 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