topic Re: Do charts support dates as a category? in ArcGIS Experience Builder Questions

Do charts support dates as a category?

DaleHarris3 — Wed, 24 Nov 2021 05:14:54 GMT

When I add a chart and connect to the data I can only select text fields as a category at the moment:

When I look to filter the data I can definitely see the date field:

Re: Do charts support dates as a category?

TimConfare2 — Wed, 01 Dec 2021 15:10:54 GMT

I am wondering the same thing. Did you ever get an answer to this?

Re: Do charts support dates as a category?

DaleHarris3 — Thu, 02 Dec 2021 01:20:33 GMT

No I haven't heard anything yet.

Re: Do charts support dates as a category?

AllenScully2 — Wed, 29 Dec 2021 19:40:09 GMT

Same question, just posted (sorry, didn't see this post) -

Very frustrating, but will reply here if I learn anything through my post.

Re: Do charts support dates as a category?

jamootzorg — Sun, 20 Feb 2022 18:06:43 GMT

I have the same issue. It is a very non-sensical issue and frustrating that there is no response from ESRI. Dates and times are a common category used in charts. They are available in the ArcGIS Dashboards charts. I am simply trying to duplicate an ArcGIS Dashboard in Experience Builder so I can have some control over the responsiveness of the layout on the smaller screens. Unable to duplicate even the simplest of charts with this issue.

Re: Do charts support dates as a category?

JavierMadoz1 — Tue, 22 Mar 2022 08:51:33 GMT

One more person asking about this improvement. Same situation as the previous post.
It seems that serial charts do not use dates. It would be great if someone from ESRI could let us know if we can expect this improvement. Thanks a lot.

Re: Do charts support dates as a category?

dan-es — Wed, 22 Jun 2022 16:43:33 GMT

I am in the same frustrating position of duplicating functionality from Dashboards into an Experience Builder project. Esri seems to always focus on the fringe benefit kinds of enhancements in their product releases, but they often miss the basics, while we wait years for implementation.

Re: Do charts support dates as a category?

DataOfficer — Wed, 12 Oct 2022 11:06:36 GMT

Same issue here. Very frustrating.

Re: Do charts support dates as a category?

Wei_Ying — Wed, 17 May 2023 21:50:49 GMT

Hello,

In the current released version, unfortunately chart does not support date field.

However, in the coming June ArcGIS online release, it will be supported.
To be noted, in bar/column chart, you can select the date as category field, but it will be treated as string, no further time setting. But line/area chart which is good for showing trending, will further support time binning setting, such as specific time interval setting.

Thanks

Re: Do charts support dates as a category?

sofoo — Wed, 17 May 2023 21:56:10 GMT

Ah this is great news!!

Re: Do charts support dates as a category?

kawakawa4 — Tue, 25 Jul 2023 04:31:19 GMT

Hi @Wei_Ying , I have tried this in Experience Builder, my date field is supported as a category field, but on the date axis, the same date appears multiple times and there are no dates on the axis where there I have no data for that date (please see attached image; the axis skips April) .

I need the date axis to be a continuous set of dates without duplicates or gaps, like in Dashboard charts when you select the 'Parse dates' option. Is there a way to do this?

Re: Do charts support dates as a category?

Wei_Ying — Tue, 25 Jul 2023 18:23:54 GMT

Hi @kawakawa4 ,

Thanks for your feedback!
Can you share how you set the time intervals?
If you are seeing multiple same date, it might because you are using interval that smaller than a day, say hour, minute. Also, if you didn't see date that have no data, you may check the option "Empty bins" that how you treat bins with no data.

Would you mind share your settings together with a view of your data attribute, so we can take a look.

Thanks,

Wei

Re: Do charts support dates as a category?

kawakawa4 — Tue, 25 Jul 2023 21:18:22 GMT

Hi @Wei_Ying , thanks for your reply. I was trying the 'Empty Bins' options but they weren't working, until I changed 'Statistics' from No aggregation to Sum. Working well now. thank you.

Re: Do charts support dates as a category?

James_Shreeve — Wed, 28 Feb 2024 09:17:26 GMT

Hi, I know this post is slightly old now and your reply is over a year ago but just wondered if there is any view to adding the ability to parse dates within the bar graph and allowing for splits at all? This is all possible in the Dashboard App (which i'm trying to migrate onto EB). I have graphs which show a total number per month which is then split into status', i'm only able to accomodate total count for the layer when using the line graph. Examples attached below. I believe the splitting of charts will be possible with the AGO update this week but still won't then be able to split via month like the line graph below...thanks!

Re: Do charts support dates as a category?

Wei_Ying — Mon, 04 Mar 2024 07:47:49 GMT

Hi @James_Shreeve ,

Appreciate for your feedback! That is a good suggestion! I have logged your requirement and will investigate with the team and work on it. Though parse date is not available for bar chart yet, the split-by is supported now in the Feb release. Please let us know if that works for you.

Thanks,
Wei

Re: Do charts support dates as a category?

James_Shreeve — Tue, 05 Mar 2024 08:58:21 GMT

Hi @Wei_Ying ,

Thank you for your reply, the splitting of the data is now available with the new AGO and this seems to work fine. Although I have noticed that the Y axis doesn't seem to wrap text so some of the text is missing off sometimes, a small thing I guess in the grand scheme of things.

Being able to parse the dates is still something needed for me to be able to use EB charts fully rather than relying on the Dashboard app. Oh and the gauge chart type not being available either. Not being able to parse dates means the values currently showing on my above line/area graph isn't representative of the number of sites per month.

Thanks again,

James

Re: Do charts support dates as a category?

Wei_Ying — Wed, 06 Mar 2024 17:42:32 GMT

Thanks! We will working on support the time parse in bar/column chart in future release.

Re: Do charts support dates as a category?

DBlake — Wed, 05 Jun 2024 15:33:13 GMT

This was an improvement but to my mind it would still be useful for bar/column charts to be able to use date fields to create columns of totals by year, month or week etc. They can look better than line/area graphs for some data. Very fiddly workarounds required at the moment to get text strings of dates displaying in the right order on bar charts...

Re: Do charts support dates as a category?

JustinH — Wed, 09 Oct 2024 21:41:45 GMT

Is there any plans for treating date fields at dates in a chart? The current limitation I am running into is not being able to bin years in a bar chart. In a line or area graph I am able to do so but the data visualization would be more impactful in a bar chart.

TIA

Re: Do charts support dates as a category?

Wei_Ying — Thu, 05 Dec 2024 23:57:15 GMT

Hi @JustinH in the recent November 2024 ArcGIS Online release, Chart widget has support time parsing when using a date field in bar or column charts. Please check out and let us know if any issue. Thank you!