Select to view content in your preferred language

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

665
9
10-11-2024 08:36 AM
JustinH
Frequent Contributor

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! 

Tags (1)
0 Kudos
9 Replies
JustinH
Frequent Contributor

JustinH_0-1728661032315.png

 

0 Kudos
AustinLewis
Occasional Contributor

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.

0 Kudos
JustinH
Frequent Contributor

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. 

0 Kudos
Wei_Ying
Esri Regular Contributor

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

0 Kudos
ThomasRickett
Regular Contributor

@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. 

0 Kudos
Wei_Ying
Esri Regular Contributor

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! 

0 Kudos
ThomasRickett
Regular Contributor

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. 

ThomasRickett_0-1739554588157.png

 

0 Kudos
Wei_Ying
Esri Regular Contributor

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

ThomasRickett
Regular Contributor

Shared with you Wei. 

0 Kudos