I was trying to create a chart using a date field as the Category Attribute but it results in a "There was an error in chart generation" message. Looking at the network traffic it looks like ArcGIS Enterprise Sites is changing date field names to all uppercase as seen in this error message "Field name 'REPORTDT' does not exist. Did you mean 'reportdt'?".
Here is a snippet from the query URL that AES generates: "EXTRACT(YEAR%20FROM%20REPORTDT)". If I edit the query URL in Notepad to change REPORTDT to reportdt, then the query URL returns a response with data.
Using other field types as the Category Attribute for the chart returns a valid chart.
"Not all those who wander are lost" ~ Tolkien
