New Chart Widget Configuration - Binning in Bar Charts (Issue?)

[JustinH]

So excited about the new updates to the chart widget in experience builder. I am currently able to reconfigure charts for the new abilities or create new charts that I had to embed from dashboards before. Awesome update! 

However, when binning the chart, Parsing the Time category to 1 year and trimming incomplete intervals (not sure if those setting matter), my chart has date ranges that begin in July instead of January. It makes the data look a little strange... 

Does anyone know of a way to change the date settings in this new chart display? Could it be the data it is reading? Reading on the Guide, it seems like it is reading and snapping to whenever your first data point is...? So If my first data point is July the entire chart is binned from a July-July basis. This seems problematic, no? We have to report on a year to year basis so that chart outputs are not helpful.... yet! 

Any help or discussion, please! 

[Wei_Ying]

Hi @JustinH thanks for your feedback!

Currently the behavior you described is as expected. Your firs point of data may start at July of 2018, so it group each bin for 1 year interval. That's why you would see July/2018-July/2019, July/2019-July/2020 and so forth. 

We are working on another enhancement to allow user decide the starting point of time binning like Jan or each year or first date of each week. It is still in research so we cannot promise the date of the new feature. But we are working on it. Please stay tuned. Thank you!

[JustinH]

Thanks for your reply. I am looking forward to the update! That would be very helpful for our reporting needs. 

[JoshBerna]

Hi @Wei_Ying,

Are there plans to allow the manual definition of bin ranges in the future, such as for slices in a pie chart or columns in a histogram? I would like to be able to match my symbology class ranges to the bins in a chart so as to represent, say, the size of classes in proportion to one another.

I am not sure which method the chart widget uses when it automatically sets bin ranges, but it effectively renders symbol class ranges created via manual interval method obsolete. Unless I'm just missing something, which I recognize is quite possible.

[Wei_Ying]

Hi @JoshBerna unfortunately so far we do not have such plan. 

>> I would like to be able to match my symbology class ranges

When you are using the same category type in Pie chart, or using the same transformation method in histogram chart as your symbology setting, don't you see same binning classes ? 

[JoshBerna]

Yes, the binning works perfectly for categorical fields. I have a couple layers using symbology from quantitative fields though, such as building condition assessments. The symbology is broken into 4 classes of values for this particular layer (ex: 0-10%, 11-20%, etc.). When brought into a chart, these classes are not honored as bins, but rather each value is treated as discrete. In the example screenshot I posted, you can see that there is a slice made for each value, rather than each symbol class of values, as would be ideal for this use case.

So, to answer your question, I do very well see the same binning classes when using a genuine categorical field, and that works great. When the field values are not a proper list however, it would be nice to be able to define bin ranges so as to match my symbol classes.

I do recognize that I could create a separate text field that would define which bin the value is in (for condition assessments, values could be good, poor, etc.) and calculate it based on the number field value, but that may not always be the case.

Thank you for your reply.

[AngusvonPrott]

Hello @Wei_Ying ,

Are there any updates on being able to set the origin date for binning?

[Wei_Ying]

It was already supported in AGOL October 2025 release. For Enterprise would be in 12.1.
The "Calendar-base" option set the calendar date for binning

[AngusvonPrott]

Hello @Wei_Ying ,

I have seen that option, and perhaps I am using it wrong, but what I am experiencing is that even when Calendar-based is set, my dates shift. For example, my complete data set covers every month for a few years down to the day; each date bin set to one month and is initially reflected in the chart as 01/01/24 - 01/02/24, this is the expected time binning. However when I filter my data and the earliest record for that initial month is the 4th day of that first month the intervals change to 04/01/24 - 04/02/24. This has a cascading effect when we are looking at years worth of data. This causes us issues when creating an insights dashboard that shows monthly change and trends using a combination of charts and dynamic texts in conjunction with filtering. When we are showing summarised monthly data, it is not reflected in the charts, they are missing days at the start of the month and extending into the next month, thus contradicting the dynamic text.

We are using experience builder in AGOL.

(Dates are in day/Month/Year)