Correct the Placement of Columns in Column Chart

N8-CORR — Wed, 24 Jan 2024 19:11:37 GMT

I've created a column chart in which the data starts at October 2023. All was well with column placement until January 2024 came along... Once January came, January became the first column in my chart. I'd like to have January be after December in this chart. (See below)

How would I go about doing that?

Re: Correct the Placement of Columns in Column Chart

AkshayHarshe — Mon, 29 Jan 2024 16:05:15 GMT

@N8-CORR

This is an expected behavior when you are aggregating into a month category w/o using a year. There are 2 ways you can represent this information:

Use a summary table or the alluvial diagram (introduced in 2023.3/ ArcGIS Online, which may or may not answer your question) would be the best representation. You want to summarize this data by date-Year --> date-Month --> Category --> count of surveys.
Split this information into 2 charts and a cross filter or a single chart and a filter widget. E.g. Create a filter widget for one of the categories (say Year) and then use it in tandem with this chart.
Cross filter

Filter Widget (aka Predefined filter)

I hope this helps.

topic Re: Correct the Placement of Columns in Column Chart in ArcGIS Insights Questions

Correct the Placement of Columns in Column Chart

Re: Correct the Placement of Columns in Column Chart