Charting events by day and month for different years

Question

I have data on the number of complaints made about illegal fireworks for my city including the timestamp for each complaint. I'd like to show a chart comparing the frequency of complaints by day of month in the run-up to Independence Day for two years (2024 and current, possibly extending this to earlier periods too) - so complaint frequency from June 1 to July 4 for 2024 and 2025. I managed to create a pivot chart in excel by creating separate fields for day-month and one for year. But I can't seem to find a way to replicate this within ArcGIS Pro and possibly extending this to a web app/dashboard. I'm sure I'm missing something very obvious, but if anyone has thoughts how to approach this I'd appreciate your input!

clt_cabq · Answer

Thanks for pointing out the data clock, I'll take a look at that, seem to have missed it when I was poking around. I used python to calculate the day/month (3-July for instance) as a text field from the time stamp and the year as a separate text field also. My pivot chart looks like this but the data clock might be a better visualization.

BobBooth1 · Answer

Have you tried the Data Clock chart type in ArcGIS Pro?

https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/charts/data-clock.htm

You can use Arcade in the Field Calculator in ArcGIS Pro to calculate out string values of day, month, and year.

For example, see the Arcade reference (in this case for ISO Month)

https://developers.arcgis.com/arcade/function-reference/date_functions/#isomonth