topic Re: Why can't I bin time fields in a Bar Chart? in ArcGIS Experience Builder Questions

Why can't I bin time fields in a Bar Chart?

JustinH — Fri, 11 Oct 2024 15:36:52 GMT

I am trying to create a graph that shows how many acres have been treated over the years. The date field is in mm/dd/yyyy.

In a line graph, I can change the bin setting to bin by year. In dashboards, I can bin the serial chart by years and force it to be a bar graph.

Does anyone know a trick to get around this? I feel like it is a simple graph functionality.

Until I figure this out, I have to embed a dashboard into my EB which does not play nice with the filters put into EB.

Any help appreciated, thanks!

Re: Why can't I bin time fields in a Bar Chart?

JustinH — Fri, 11 Oct 2024 15:37:17 GMT

Re: Why can't I bin time fields in a Bar Chart?

AustinLewis — Fri, 11 Oct 2024 15:55:43 GMT

I really have no business trying to solve this as I have never used EB nor have I made many bar charts with ESRI software. But I am curious....

Does it allow you to bin by fields other than the date? Is the date field a date/datetime field type? If so, maybe it doesn't like the field type? In that case you could potentially add a field called year and just make it a Long field type.

Could be totally wrong, but just a thought.

Re: Why can't I bin time fields in a Bar Chart?

JustinH — Fri, 11 Oct 2024 20:39:07 GMT

Not in a bar chart only a line graph. The date field is fine in dashboards or if I use the line charts in EB.

Re: Why can't I bin time fields in a Bar Chart?

Wei_Ying — Thu, 24 Oct 2024 06:28:19 GMT

Hi, thanks for your feedback.
In the coming November release, Bar chart will support time parse. Thanks.

Re: Why can't I bin time fields in a Bar Chart?

ThomasRickett — Mon, 23 Dec 2024 19:56:15 GMT

@Wei_Ying Hello, I have a similar issue with the Time only field not parsing for a bar chart. Time only fields are not an option in charts at all. Line graphs or bar charts.

Re: Why can't I bin time fields in a Bar Chart?

Wei_Ying — Fri, 03 Jan 2025 01:22:51 GMT

Hello,

Time parsing for bar and column chart has been supported in ArcGIS Online November release. For Enterprise it would be until 11.5. Thanks!

Re: Why can't I bin time fields in a Bar Chart?

ThomasRickett — Fri, 14 Feb 2025 17:36:59 GMT

Using ExB in AGO, I have a time-only field and it does not show up in the category field as an option for bar, column or line charts. I used to be able to make a line chart of a time field. But that capability is gone now.

Re: Why can't I bin time fields in a Bar Chart?

Wei_Ying — Thu, 27 Mar 2025 20:48:33 GMT

@ThomasRickett would you be able to share your app or data for investigation?

Re: Why can't I bin time fields in a Bar Chart?

ThomasRickett — Wed, 02 Apr 2025 19:55:47 GMT

Shared with you Wei.