topic Re: Insights does not automatically divide date/time fields into parts that can be used as string fields in other visualizations in ArcGIS Insights Questions

Insights does not automatically divide date/time fields into parts that can be used as string fields in other visualizations

ThaoNDP — Wed, 24 Jan 2018 04:27:46 GMT

I am working on date fields in Insight app. As I have read on the Esri help websites that Insights will automatically divide date/time fields into parts that can be used as string fields in other visualizations, such as Year, Month, Day of a week, or Hour. But my own date field was not working like that. If there are no subfields divided, it's hard to create the column/bar charts except time series charts. You can find the detail in the following screenshot:

I would like to create some charts as below:

Any solution to this problem?

Thank you very much, guys!

Thao Nguyen

Re: Insights does not automatically divide date/time fields into parts that can be used as string fields in other visualizations

ThaoNDP — Wed, 24 Jan 2018 08:08:18 GMT

I have just found out that the subfields of date fields only appear if the data is added from an excel file, not added from an ArcGIS Server web services. Is this a limitation?

Re: Insights does not automatically divide date/time fields into parts that can be used as string fields in other visualizations

Khalid_SaddiqueAkbar — Fri, 26 Oct 2018 04:54:39 GMT

Dear

I had the same issue but took the following actions

Create a new field in insights table view
Calculate equal to old field

New field was properly divided into parts by insights