Chart doesn't sort date properly
I'm trying to make a chart that shows the occurrence of certain events over time, but the chart sorts the dates incorrectly. It's sorting based off of the day digit so since there is a 1 in the number 12 it is going before the 9th. Any thoughts on how to change this? I'm using data that's being brought in from a Survey123 form so I was hoping this would be compatible, but it seems like I'm going to have to change the format of the date in order for it to work properly.
Thanks for the help Rachel. It seems to be recognizing it as a date as you can see on the left side it's showing a little calendar next to the field and allowing me to choose "year, month, day, or hour". I tried it with the "created date" as well and it does the same thing. I'm not sure if it's just because I'm loading it from Survey123. I'll try to load it from a different source and see what happens.
This is a completely different feature that I loaded from ArcPro and it seems to be doing the same thing.
Hey Rachel, thanks for sticking with me. The feature that I brought in is a simple survey123 form with geolocations, no dashboards or other apps involved. In ArcGIS Hub I just clicked Layout > Chart and selected the survey as the "Data" to display. The survey has a date field and that's the field I selected to make the chart from.
